is there a way to add today’s date in clay via formulas or something else
Yes, you can add today's date in Clay using formulas. Here are two methods:
1. Use a formula without dependency:
Write moment().format("MMMM, D YYYY")
in a formula column. This will dynamically populate the current day's date.
2. Use the Action Format Date/Time:
• Add a new column and select "Action Format Date/Time"
• Input the date (you can use a reference to the "Created At" column)
• Choose your desired date format
• (Optional) Specify timezones and locale
• Configure run settings for auto-update
Both methods will give you a dynamic column with today's date. Choose the one that best fits your needs.