Date and time values
Provide a fixed date or time
Each node represents one or more fixed values:
-
Date - a calendar date, e.g. 14 July 2026
-
Date Time - a calendar date and time, e.g. 14 July 2026 15:21:34
-
Seasonal - a date that recurs every year, ignoring the year itself, e.g. 17 August
-
Time - a 24-hr time of day, ignoring the date itself, e.g. 09:00, 16:20
Usage
These nodes are inputs, so you can add them to the segments of these comparison nodes:
Compatibility
These nodes each fill one segment. The other must hold a reference node of the same value type.
| Node | Accepted Value Type | Notes |
|---|---|---|
| Attribute | Same as the Value node | Use the Pathfinder to choose an attribute, on the queried item or a linked item |
| Property | Date Time | Only if Last edit date is chosen and the comparison is Less than or Greater than |
Options
Select a node to access its options:
- Delete - remove the node from the segment.
- Parameter - select a compatible parameter to use as a placeholder. The value is provided when the query runs.
Alternatively, select the relevant field. Set one or more fixed values with the calendar picker:
-
Date - defaults to today's date.
-
Date Time - defaults to the current date and time.
-
Seasonal - defaults to today.
-
Time - defaults to the current time.
Examples
Date
Fetch holidays that start after 14 July 2026.
In AQS terms:
Fetch all items of the Holiday design where their Start Date attribute is greater than 14 July 2026.
See JSON code
This code may reference designs, interfaces, attributes or items that don't exist in your company project.
{
"type": "Query",
"properties": {
"collectionCode": "Live",
"dodiCode": "designs_holidays"
},
"children": [
{
"type": "GreaterThan",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_holidaysStartDate"
}
},
{
"type": "Date",
"properties": {
"value": ["2026-07-14T00:00:00.000Z"]
}
}
]
}
]
}
Date Time
Fetch all defects raised between 1 July 2026 and 30 September 2026.
In AQS terms:
Fetch items of the Defects interface where their Reported Date attribute is greater than 1 July 2026 and less than 30 September 2026.
See JSON code
This code may reference designs, interfaces, attributes or items that don't exist in your company project.
{
"type": "Query",
"properties": {
"collectionCode": "Live",
"dodiCode": "designInterfaces_defects"
},
"children": [
{
"type": "And",
"children": [
{
"type": "GreaterThan",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_defectsReportedDate"
}
},
{
"type": "DateTime",
"properties": {
"value": ["2026-06-30T23:00:00.000Z"]
}
}
]
},
{
"type": "LessThan",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_defectsReportedDate"
}
},
{
"type": "DateTime",
"properties": {
"value": ["2026-09-29T23:00:00.000Z"]
}
}
]
}
]
}
]
}
Seasonal
Fetch all seasonal date intervals that start before 14 February.
In AQS terms:
Fetch items of the Seasonal Date Intervals design where their Start Date is less than 14 February.
See JSON code
This code may reference designs, interfaces, attributes or items that don't exist in your company project.
{
"type": "Query",
"properties": {
"collectionCode": "Live",
"dodiCode": "designs_seasonalDateIntervals"
},
"children": [
{
"type": "LessThan",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_seasonalDateIntervalsStartDate"
}
},
{
"type": "Seasonal",
"properties": {
"value": ["1972-02-14T00:00:00.000Z"]
}
}
]
}
]
}
Time
Fetch all working hours that end after 17:30.
In AQS terms:
Fetch items of the Working Hours design where their End Time attribute is greater than 17:30:00.
See JSON code
This code may reference designs, interfaces, attributes or items that don't exist in your company project.
{
"type": "Query",
"properties": {
"collectionCode": "Live",
"dodiCode": "designs_hoursOfOperation_62fe229ade52b60342bd15cc"
},
"children": [
{
"type": "GreaterThan",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_hoursOfOperationEndTime_62fe22e1de52b60342bd1a2e"
}
},
{
"type": "Time",
"properties": {
"value": ["1970-01-01T17:30:00.000Z"]
}
}
]
}
]
}