Clay Icon

Using Current Date for Rolling Dates in Formulas

Β·
Β·

Can I use current date in a formula, so I can create a rolling date in my dormula

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    Yes, you can use the current date in a formula to create a rolling date. You can use the moment() function to get the current date and time. For example, you can use moment().format("MMMM, D YYYY") in your formula to dynamically populate the current day's date. To create a rolling date, you can use the AI formula generator to help you construct more complex formulas. For instance, you could create a formula that calculates the number of days between the current date and another date column in your table. If you need further assistance with creating specific rolling date formulas, feel free to ask for more details.

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·