date() returns the current date for calculations:
[Event.Date]-[Date] - returns the number of days to the date of the event
date(a) returns the current date formatted according to a:
date("dd/mm/yyyy") - returns for example 01/07/2014
date(a;b) returns the date b formatted according to a:
date("mm/yyyy"; [DateOfBirth]) - could return for example 05/1970
the function can be used to also extract dates / times from a datetime string such as the [Created] or [Modified] fields.
Date Formats:
| d | Day of Month (without leading zeroes) |
| dd | Day of Month (with leading zeroes) |
| ddd | Day of Month as Ordinal value |
| m | Month (without leading zeroes) |
| mm | Month (with leading zeroes) |
| mmm | Month as short text (English & German only) |
| mmmm | Month as long text (English & German only) |
| yy | 2-digit Year |
| yyyy | 4-digit Year |
| e | Day of Week as number (1-7) |
| ee |
Day of Week as short text (English & German only) |
| eee | Day of Week as long text (English & German only) |
| a | Day of Year |
| ww | Week number |
| isoweek |
Year and Week number |
| unix | Unix time |
Time Formats:
| hh | Hours |
| nn | Minutes |
| ss | Seconds |