DF: date format (represent a time instant as text)
Syntax
df(format, [date])Arguments
- format: Format to be used for the date, see examples
- date: Date to be used. The Date can be returned by some other function or you can use text. For text dates you can both set it statically using the format '1955y11M12d22h04m00s' to express year 1955, month 11, day 12 at 22:04:00 (all fields are optional), or use 'a/r' (add/remove) operators, so, for example 'a12m3s' will add 12 minutes and 3 secs to current date.
Examples
| Formula | Description |
|---|---|
| $df(h:mm)$ | Hours and minutes with padding zero |
| $df(hh:mma)$ | Hours with leading zero, minutes and AM/PM marker (if 12h format in use) |
| $df(d MMM yyyy)$ | Current day number, month short name and full year |
| $df(dd/MM/yyyy)$ | Day / Month / Year numbers |
| $df(d)$$tc(ord, df(d))$ | Current day number with ordinal suffix |
| $df(hh)$ | Hours with padding zero |
| $df(mm)$ | Minutes with padding zero |
| $df(dd)$ | Day of the month with padding zero |
| $df(EEEE)$ | Current day name |
| $df(EEE, a1d)$ | Tomorrow's short day name |
| $df(MMMM)$ | Current month name |
| $df(D)$ | Day of year (number) |
| $df(w)$ | Week of year |
| $df(e)$ | Current day of the week (number, as per app settings) |
| $df(f)$ | ISO day of week (number, 1=Monday) |
Reference
| Format | Description |
|---|---|
| h | Hour of day (auto 1~12/0~23) |
| hh | Hour of day padded (1~12/0~23) |
| m | Minute of hour |
| mm | Minute of hour zero padded |
| s | Second of minute |
| ss | Second of minute zero padded |
| a | AM/PM marker (hidden in 24h) |
| k | Hour of day (auto 0~11/1~24) |
| kk | Hour of day padded (0~11/1~24) |
| dd | Day of month (number padded) |
| M | Month of year (number) |
| MM | Month of year (number padded) |
| MMM | Month of year (word short) |
| MMMM | Month of year (word long) |
| E | Day of week (word short) |
| EEEE | Day of week (word long) |
| D | Day of year (number) |
| DDD | Day of year (number padded) |
| e | Day of week (number) |
| f | ISO day of week (number, 1=Monday) |
| F | Week of Month |
| o | Days in current month (number 0-31) |
| d | Day of month (number) |
| dd | Day of month (number padded) |
| A | AM/PM marker (always visible) |
| H | Hour of day 0-23 (fixed) |
| S | Second since epoc (unix time) |
| Z | Time zone offset from GMT (in seconds) |
| z | Time zone indicator (es PST) |
| W | Time (hh:mm) as text |
| zzzz | Time zone description (es Pacific Standard Time) |