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 "workdays" (ignores Saturday and Sunday), "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 "minutes", "hours", "weeks", "months" or "years"
You can also add the 4th optional parameter, which is the date format, for example "MMMM YYYY" will show the date in the "April 2045" format, more options here

DATEFORMAT(@DateField, "YYYY DD, MM") will change the date format, for example "MMMM YYYY" will show the date in the "April 2045" format, more options here

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)

DATE(2024, 1, 22) is a number that represents January 22nd, 2024. So you can compare that with TODAY() for example, which is also a number

To see if a user selected date is greater than a fixed date, you can do: DATEDIF(@UserDate, DATE(2024, 1, 22)) > 0

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