Skip to main content

$$date

Date manipulation and formatting utility

note

input must be a Date in ISO-8601 format or Date or Instant

tip

Useful to be used in conjunction with #now as input

Usage​

{ 
  "$$date": /* Date or Date-Time in ISO-8601 format */,
  "format": "ISO" /* or GMT / DATE / ADD / SUB / DIFF / EPOCH / FORMAT / ZONE */
}
"$$date([format]):{input}"
note

Concrete values in the usage example are default values.

Returns​

string (date-time)

Arguments​

ArgumentTypeValuesRequired / Default ValueDescription
PrimarystringYesDate or Date-Time in ISO-8601 format
formatenumISO/ GMT/DATE/ADD/SUB/DIFF/ EPOCH/FORMAT/ZONEISOFormatter to use

Examples​

Input

Definition

Output

"2020-12-31T12:34:56.78Z"
"$$date:$"
"2020-12-31T12:34:56.780Z"
Test
"2020-12-31"
"$$date:$"
"2020-12-31T00:00:00Z"
Test
"2020-12-31T12:34:56.78Z"
"$$date():$"
"2020-12-31T12:34:56.780Z"
Test
"2020-12-31T12:34:56.78Z"
"$$date(iso):$"
"2020-12-31T12:34:56.780Z"
Test
"2020-12-31T12:34:56.78Z"
"$$date(ISO,0):$"
"2020-12-31T12:34:56Z"
Test
"2020-12-31T12:34:56.78Z"
"$$date(iso,3):$"
"2020-12-31T12:34:56.780Z"
Test
"2020-12-31T12:34:56.78Z"
"$$date(iso,6):$"
"2020-12-31T12:34:56.780000Z"
Test
"2020-12-31T12:34:56.78Z"
"$$date(ZONE,America/New_York):$"
"2020-12-31T07:34:56.78-05:00"
Test
"2023-01-01T00:00:00Z"
"$$date(ZONE,EST):$"
"2022-12-31T19:00:00-05:00"
Test
"2020-12-31T12:34:56.78Z"
"$$date(GMT):$"
"Thu, 31 Dec 2020 12:34:56 GMT"
Test
"2020-12-31T12:34:56.78Z"
"$$date(date):$"
"2020-12-31"
Test
"2020-12-31T12:34:56.78Z"
"$$date('date'):$"
"2020-12-31"
Test
"2020-12-31T12:34:56.78Z"
"$$date(format,'dd.MM.yyyy'):$"
"31.12.2020"
Test
"2023-01-01T00:00:00Z"
"$$date(format,'yyyy-MM-dd HH:mm'):$"
"2023-01-01 00:00"
Test
"2023-01-01T00:00:00Z"
"$$date(format,'yyyy-MM-dd HH:mm',UTC):$"
"2023-01-01 00:00"
Test
"2023-01-01T00:00:00Z"
"$$date(format,'yyyy-MM-dd HH:mm','America/New_York'):$"
"2022-12-31 19:00"
Test
"2020-12-31T12:34:56.78Z"
"$$date(epoch):$"
1609418096
Test
"2020-12-31T12:34:56.78Z"
"$$date(epoch,MS):$"
1609418096780
Test
" +01:00 "
"$$date(ZONE,$):2023-01-01T00:00:00Z"
"2023-01-01T01:00:00+01:00"
Test
"+01:00"
"$$date(ZONE,$):2023-01-01T00:00:00Z"
"2023-01-01T01:00:00+01:00"
Test
"2020-12-31T00:00:00Z"
"$$date(add):$"
null
Test
"2020-12-31T00:00:00Z"
"$$date(ADD,MILLIS,100):$"
"2020-12-31T00:00:00.100Z"
Test
"2020-12-31T00:00:00Z"
"$$date(add,SECONDS,59):$"
"2020-12-31T00:00:59Z"
Test
"2020-12-31T00:00:00Z"
"$$date(add,MINUTES,59):$"
"2020-12-31T00:59:00Z"
Test
"2020-12-31T00:00:00Z"
"$$date(add,HOURS,24):$"
"2021-01-01T00:00:00Z"
Test
"2020-12-31T00:00:00Z"
"$$date(ADD, DAYS, 1):$"
"2021-01-01T00:00:00Z"
Test
"2020-12-31T00:00:00Z"
"$$date(add,days , 1):$"
"2021-01-01T00:00:00Z"
Test
"2020-12-31T00:00:00Z"
"$$date(add,MONTHS,1):$"
"2021-01-31T00:00:00Z"
Test
"2020-12-31T00:00:00Z"
"$$date(add,YEARS,1):$"
"2021-12-31T00:00:00Z"
Test
"2020-12-31T00:00:00Z"
"$$date(SUB,HOURS,23):$"
"2020-12-30T01:00:00Z"
Test
"2020-12-31T00:00:00Z"
"$$date(sub,DAYS,1):$"
"2020-12-30T00:00:00Z"
Test
"2020-12-31T00:00:00Z"
"$$date(sub,MONTHS,1):$"
"2020-11-30T00:00:00Z"
Test
"2020-12-31T00:00:00Z"
"$$date(sub,YEARS,1):$"
"2019-12-31T00:00:00Z"
Test
"2020-12-31T00:00:00Z"
"$$date(add,DAYS,-1):$"
"2020-12-30T00:00:00Z"
Test
"2020-12-31T00:00:00Z"
"$$date(add,YEARS,-1):$"
"2019-12-31T00:00:00Z"
Test
{
  "date": "2020-12-31T00:00:00Z",
  "amount": 2,
  "unit": "HOURS"
}
"$$date(add,$.unit,'$.amount'):$.date"
"2020-12-31T02:00:00Z"
Test
{
  "a": "2024-01-01",
  "b": "2025-01-01"
}
"$$date(DIFF,DAYS,$.b):$.a"
366
Test
"2024-01-01"
"$$date(DIFF,SECONDS,$):1970-01-01"
1704067200
Test