Lists Prefilter for Current Date and Default Empty Date (0000-00-00 00:00:00)

[prutudom]

Good morning, how are you this morning.

I would like to be able to perform prefilter query by date which is either >= NOW() or '0000-00-00 00:00:00'.

Element: End Date
Condition: GREATER THAN OR EQUALS
Value: NOW()
Type: Query
Access: Public

Since this query only filter the greater date portion.

I would like to be able to use this query filter.

AND ( file.date_end >= (NOW()) ) OR file.date_end = '0000-00-00 00:00:00' )

What would be your suggestion to accomplished this query.

Thank you very much.