Expression evaluation error : Date out of range: Invalid day (APNX-1-4205-018)
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!
