Hi Team,
How do we filter the query entity with datetime (2023-01-13 14:03:59) like how we filter a string.
Can anyone please tell how can we filter the entity with one specific datetime value?
Eg:
a!queryFilter( field: "value", operator: "=", value: "test" ),
Discussion posts and replies are publicly visible
See below an example. I suggest you use the Query Editor for more options.
filters: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: 'recordType!Record.fields.createdOn', operator: "=", value: now() ), a!queryFilter( field: 'recordType!Record.fields.updatedOn', operator: "between", value: /* Trailing 3 Months */ toDatetime({eomonth(today(),-4) + 1, eomonth(today(),-1) + 1}) ) }, ignoreFiltersWithEmptyValues: true )