Clay Icon

Error in Formula for Funding Date Between Two Dates

·
·

I am getting an error while using this formula. This is my text for the formula: "If "Funding date column" is between January 1, 2024 and February 15, 2025 THEN Return Y" Formula Generated : moment({{Funding Date}}).isBetween("2024-01-01", "2025-02-15", undefined, "[]") ? "Y" : "" What is the issue here?

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Try refreshing your browser using Cmd/Ctrl + Shift + R to resolve the "Error evaluating formula" issue in your output column. If the error persists after refreshing, please request human support to help troubleshoot the specific formula syntax, as they can better analyze the exact error you're encountering with the moment.js implementation.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Is that what you were looking for?

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Great! Let me know if you have more questions.

  • Avatar of Sahil S.
    Sahil S.
    ·
    ·

    It got solved. I tweaked the formula for a date greater than version

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hi Sahil S.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Thank you so much for sharing your feedback Sahil S.!

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Glad to hear you found a solution! Let me know if you need anything else.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Thank you so much for sharing your feedback Sahil S.!