Date

Pick a date or a date range. The Date format can be set in Settings / Config / Localization. If you need a Date format that is not there, let us know.

Config

Style

Most of the style settings are self-explanatory, but here are a few tips and tricks:

How it works in Formulas

If this is a Date Range (From/To Dates), the value of the field will be the number of days between the dates. Otherwise the value of the field will be a text with the selected date.

If you have two separate date fields you can calculate the difference between the dates with the DATEDIF function:
DATEDIF(@DateField1, @DateField2, "days") will return the number of days between the two dates.
You can replace "days" with "weeks", "months" or "years"

DATEDIF(@DateField, TODAY()) will return the number of days between the date in the DateField and today.

If you want to calculate a date based on a date field you can use the DATEADD function:
DATEADD(@DateField, 3, "days") will show the date 3 days from now
You can replace "days" with "weeks", "months" or "years"

Use the WEEKDAY function to return the number of the day in the week:
WEEKDAY(@DateField) will return 1 for Monday, 2 for Tuesday, 3 for Wednesday, etc

YEAR, MONTH and DAY functions will return the month, year and day as numbers:
YEAR(@DateField) will return the year as a four digit number (2020, 2030, etc)
MONTH(@DateField) will return the month as a number (1 for January, 2 for February, etc)
DAY(@DateField) will return the day of the month as a number (1, 2, 3)

Need Help?
Already checked the help docs? We're quick to answer and friendly
Thanks!
We'll be back with a reply very soon.
Send message