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!

  Discussion posts and replies are publicly visible

Parents Reply Children