Skip to main content

Groups - JSON Range Search with Dates

Examples on how to set up Range Searches for Dates in Groups

S
Written by Support
Updated this week

Use the YYYYMMDD format, where the year comes first, followed by the month, and then the day, (eventually hours, minutes, seconds) because we use a text range search.

  • YYYY<any symbols or empty>MM<any symbols or empty>DD<any symbols or empty>HH<any symbols or empty>mm<any symbols or empty>SS

  • YY<any symbols or empty>MM<any symbols or empty>DD<any symbols or empty>HH<any symbols or empty>mm<any symbols or empty>SS

Example1:

{
“searchPattern”: [
{
“property”: “Fabrication/End”,
“range”: {
“min”: “today.format(\”YYYYMMDDHHmmSS\”)”,
“max”: “(today+14days).format(\”YYYYMMDDHHmmSS\”)”
},
“exact”: true
}
]
}

Example2:

{

“searchPattern”: [

{

“property”: “Fabrication/End”,

“range”: {

“min”: “today.format(\”YYYYMMDDz\”)”,

“max”: “(today+14days).format(\”YYYYMMDDz\”)”

},

“exact”: true

}

]

}

Did this answer your question?