This site uses cookies and similar technologies.

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

I understand
1142 Posts
Bucklash
26 days 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
4218 Posts
Kadministrator
21 days ago
1
Level 1

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

1142 Posts
Bucklash
19 days 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