query filter fields with date and time stored with text datatype .

Certified Associate Developer

Hello community,

Is there a way to filter in a query on a text field with date time other then changing the datatype.
e.g. a field lastUpdated with text datatype has a value 8/22/2021 2:55 PM GMT+02:00.
If the filter is configured like:

filters: {
            a!queryFilter(
              field: "startDate",
              operator: "<",
              value: "9/22/2021 2:55 PM GMT+02:00"


it works fine if the month in the value is a one digit.

it fails if the month in the value is two digits e.g.: "10/22/2021 2:55 PM GMT+02:00"

Is it possible to convert/alter the startDate value before applying the filter, or add a column to to the result with the date time converted to date time.

Kind Regards,

Erik 

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data