format()
Las funciones de format formatean un número (primer parámetro) según un time format (segundo parámetro). Ejemplo:
format(123.45; "h:mm:ss,k") - devuelve 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
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 |
Time Formats:
| hh | Hours |
| nn | Minutes |
| ss | Seconds |
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) crea una cadena especial que generará un tiempo de ejecución en las listas que muestra el tiempo transcurrido desde la hora.
Si no se indica el formato, se utilizará HH:mm:ss.
Si el formato se expresa con un signo "-", ElapsedTime mostrará una cuenta regresiva hasta el tiempo.
ElapsedTime no funcionará para eventos de varios días en los que el tiempo supere las 24 horas.
AgeOnDate()
AgeOnDate(yyyy;mm;dd) returns a participant's age on a specified date entered with 3 parameters; year month and day..