list filter issue with Null date field
-
Hello
I would like to select a record that has several dates fields when at least one of those dates is older than 3 months ago.Short code with filter :
[pdb_list template=edit-link search=true filter=” date1<-3_months&date2<-3_months “]generated in log :
SELECT ….WHERE p.date1 < CAST(1604188800 AS SIGNED) AND p.date2 < CAST(1604188800 AS SIGNED) ORDER BY….my problem :
when one of the dates is NULL (not filled in) the result is FALSE no matter what…how can I make it work?
thanks for the help
Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
- The topic ‘list filter issue with Null date field’ is closed to new replies.