[Resolved] How can I make a Custom Date Filters?

[Author]

Posts

[alixB]

I'm trying to display futures events in a view. I have events (post) with a meta key event_date stored with this format YYYYMMDD.

And I would like to display only the futures events, so the logic would be "Only the events dates higher than today" (YYYYMMDD > YYYYMMDD)

But, in Date Filters is only using timestamp (https://toolset.com/documentation/user-guides/date-filters/). So that's not possible with my data stored.

Can I add a new custom date filter to add this format YYYYMMDD? How?

Thank you!

[Minesh]

Hello. Thank you for contacting the Toolset support.

As I understand you have a date (event_date ) custom field created using Types plugin and you want to filter your event posts for future events. i.e. "Only the events dates higher than today" (YYYYMMDD > YYYYMMDD).

Types date custom field stores its value as Unix timestamp to the database. So to filter the events greater than today. What if you try to add the custom field query filter from "Query Filter" section of your view:
=> https://toolset.com/documentation/user-guides/filtering-views-by-custom-fields/

Please check the following screenshot:
=> https://toolset.com/wp-content/uploads/2012/07/Filtering-Views-Query-by-Custom-Fields2.png
- So you should try to add query filter - where you should add TODAY() in constant box:

Select items with field:
event_date  is a number greater than TODAY()

[alixB]

I'm not using the Types plugin problem, so my field is not stored as a timestamp but I will use Types for this part.
Thank you!