DP: Creates a date from text

Syntax

dp(date)

Arguments

  • 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
$dp(0h0m0s)$ Today's midnight
$dp(01M01d0h0m0sa1y)$ New year's eve
Was this article helpful?
0 out of 1 found this helpful