1283 Posts
Bucklash
5 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 Book for SEBLOD
4229 Posts
Kadministrator
5 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
Bucklash
5 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 Book for SEBLOD