Skip to main content

Relative time period

Log in to add to favourites

Used stand-alone to list records created in the last 24 hours.

JSON
1
2
3
4
5
6
7
8
9
10
{ "pageIndex": 0, "pageSize": 25, "where": [ { "field": "sys.version.created", "greaterThanOrEqualTo": "-1d" } ] }

Used stand-alone to list records created since the start of the last week of the previous month.

JSON
1
2
3
4
5
6
7
8
9
10
{ "pageIndex": 0, "pageSize": 25, "where": [ { "field": "sys.version.created", "greaterThanOrEqualTo": "-1M 1w" } ] }

Used as a parameter to an Expression Function to list records created last year.

JSON
1
2
3
4
5
6
7
8
9
10
11
12
13
14
{ "pageIndex": 0, "pageSize": 25, "where": [ { "field": "sys.version.created", "greaterThanOrEqualTo": "startOfYear(-1)" }, { "field": "sys.version.created", "lessThanOrEqualTo": "endOfYear(-1)" } ] }

Still need help?

New support request