DF: Format a Date into 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(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
W Time (hh:mm) as text
ZZZ Time zone id
Was this article helpful?
1 out of 2 found this helpful