format()
The format functions formats a number (first parameter) according to a time format (second parameter). Example:
format(123.45; "h:mm:ss,k") - returns 0:02:03,4
date()
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.
now()
now() returns the current date and time for calculations:
now()-[Created] - returns the number of days ago the participant has been created.
ElapsedTime()
ElapsedTime(time; format) creates a special string which will generate a running time on lists which shows the time elapsed since time.
If format is not given, HH:mm:ss will be used.
If format is expressed with a "-" sign, the ElapsedTime will show a countdown to time.
ElapsedTime will not work for multi-day events where the time goes over 24 hours.
AgeOnDate()
AgeOnDate(yyyy;mm;dd) returns a participant's age on a specified date entered with 3 parameters; year month and day..