1279 Posts
Bucklash
2 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

Get a VIP membership
4229 Posts
Kadministrator
2 years ago
1
Level 1

t1.date >= '2019-05-22 11:09:41' seems correct, try looking into other parts of the query

1279 Posts
Bucklash
2 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!!

Get a VIP membership