The filter does not work correctly with Date Only fields

Created on 11 August 2022, almost 2 years ago
Updated 20 October 2023, 8 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

Needs review

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.69.0 2024