Hi everyone,
I'm filtering this record to only query cases with completed date within nearest 5 days.
My query code is as below:
a!queryFilter( field: recordType!Record.completedDateTime, operator: ">", value: datetime( year(now()), month(now()), day(now()) - 5, 00, 00, 00, 00 ) )
The code worked well last week, but this morning it suddenly showed this error:
The Requested Record Type Is Not Available The default filters expression for record type failed to evaluate. Details: [Expression evaluation error at function a!queryFilter [line 4]: Date out of range: Invalid day]. (APNX-1-4205-018)
I've checked the DB and data for this column was the same structure as last week: datetime /* mariadb-5.3 */ . For example: 2022-08-01 04:14:49.
Any one has faced the same error code? Please give me some suggestion if possible...
Thank you!
Discussion posts and replies are publicly visible