Let's say you want to add a new column that contains today's date (no matter when you check). Or, you want to use today's date in some other calculation.
Use the following formula:
This will return a datetime value e.g. 2018-11-21 11:09:45
Want to change this to a simple date? Learn how to convert a datetime column to a date column here.
Have a question? 🧐
We're on standby to help! To chat with us, click the blue Intercom button in the bottom right of Trevor's interface.