Clay Icon

Formula to Evaluate Created At Date in Relation to Specific Date

·
·

I need a formula that evaluate the {{Created At}} if it is after or before the specific date.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    You can use date comparison operators to evaluate if {{Created At}} is before or after a specific date. Here are the available operators: For dates after a specific date: ** Use > (greater than) ** Example: {{Created At}} > "2023-01-01"For dates before a specific date: ** Use < (less than) ** Example: {{Created At}} < "2023-01-01"You can also include the specified date in your comparison using: ** > = (greater than or equal to) for on or after a date ** <= (less than or equal to) for on or before a date Source: <https://www.clay.com/university/guide/comparison-operators|Comparison operators | Documentation | Clay University>

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Did that answer your question?

  • Avatar of Lemuel
    Lemuel
    ·
    ·

    nevermind I got it worked with new Date({{Created At}}) > new Date("2025-02-12T00:00:00Z") the AI always provide moment() which does not work.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Got it! Let me know if you have any other questions.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

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