DF: Format a Date into text


df(format, [date])


  • 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.


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)


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)
Was this article helpful?
3 out of 5 found this helpful