Date and Time Greater than Now Not Working

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
-	10:00 – 13:00	10:00 – 13:00	10:00 – 13:00	10:00 – 13:00	10:00 – 13:00	-
-	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	-

Supporter timezone: Asia/Kolkata (GMT+05:30)

This topic contains 1 reply, has 2 voices.

Last updated by Minesh 5 months, 2 weeks ago.

Assisted by: Minesh.

Author

Posts

September 20, 2024 at 5:12 am #2749743

tacoF

I have a view in which the condition is to show only records with a date and time greater than now. It doesn't work. I'm attaching a screenshot:
- date today
- field info
- field value
- condition for the view
When the condition is removed the record show up on the front end.

September 20, 2024 at 8:28 am #2749887

Minesh

Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

Hello. Thank you for contacting the Toolset support.

Toolset custom date field stores Unix Timestamp value to the database and that is the number type.

So, with your "Query Filter" you added for your date custom field, what if you try to select option "Numeric" instead of "DATETIME" and add the query filter and check if that help you to resolve your issue.

September 20, 2024 at 8:37 am #2749889

tacoF

That worked, thank you. Strange though.