This site uses cookies and similar technologies.

If you don't change browser settings, you agree to it.

I understand
1183 Posts
Bucklash
1 month 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
4228 Posts
Kadministrator
1 month ago
1
Level 1

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

1183 Posts
Bucklash
1 month 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