1283 Posts
4 years ago
2
Topic
Hi folks
- In my DB I have "2019-05-29 17:30:00"
- My field shows the Set Data Type is "DATETIME"
RESULT = NO My search field has - Live Value/2 as "now" (no quotes on field, just shown here to be clear) - Match/3 as "Future (> or =)"
RESULT = YES My search field has - Live Value/2 as "2019-05-22 11:09:41" (no quotes on field, just shown here to be clear) - Match/3 as "Future (> or =)" - DEBUG OUTPUT shows "AND t1.date >= '2019-05-22 11:09:41'"
Any tips/clues/questions
Thanks
Jon
4229 Posts
4 years ago
1
Level 1
t1.date >= '2019-05-22 11:09:41' seems correct, try looking into other parts of the query
1283 Posts
4 years ago
0
Level 2
Well, I was looking in the wrong place.
It turns out I had "System - Page Cache" enabled.
This was causing other dramas, too, like log in weirdness.
"The security token did not match." upon login on frontend after upgrading to 3.7
Good old Sozzled!!