This site uses cookies and similar technologies.

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

I understand
1219 Posts
Bucklash
6 months 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 months ago
1
Level 1

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

1219 Posts
Bucklash
5 months 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