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
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 |
It is also possible to use basic Time Formats with date formatting.