The filter does not work correctly with Date Only fields

Created on 11 August 2022, over 2 years ago
Updated 31 August 2024, 3 months ago

Problem/Motivation

I have fields of type Datetime but configured for date. Comparison with such fields in the module does not work correctly.

Steps to reproduce

Create a Datetime field, select Date type -> Date only in the field settings. This type of comparison does not work properly 2022-01-01T00:00:00 >= 2022-01-01
SELECT STRCMP("2022-01-01T00:00:00", "2022-01-01T00:00:00"); = 0
SELECT STRCMP("2022-01-01T00:00:00", "2022-01-01"); = 1

🐛 Bug report
Status

RTBC

Version

2.0

Component

Code

Created by

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Production build 0.71.5 2024