[Resolved] How to add a date filter to a View

[Author]

Posts

[larryB-3]

Tell us what you are trying to do? I would like to create a CPT for Alerts. My CPT would just contain a few fields, one of them being a date to expire the CPT. For example, I would have an Alert that would appear for 4 days and expire on 08/09/2018. I would create a view that would show any alerts that have not expired on my home page. Is there a way to do this with Toolset?

[Nigel]

Hi Larry

If you add Alert posts from the front-end using Toolset Forms, then yes, you can use the post expiration feature.

See the documentation here: https://toolset.com/documentation/user-guides/automatic-post-expiration/

However, that involves giving all posts created with the form the same expiration period (e.g. after 4 days), though you can modify this on a post-by-post basis using the Forms API.

But if you are displaying the Alerts with a View you don't really need this.

Just add your field for the date/time when the Alert post should "expire".

Then create a View to show unexpired Alerts which has a Query Filter for that expiry date field to only show posts with an expiry date after NOW(). (See https://toolset.com/documentation/user-guides/date-filters/)

Unlike the Forms post expiration feature, which changes the status of posts from published, you will simply not be listing the expired Alert posts, even though they are still published.

[larryB-3]

Thanks, but I'm stuck. Nothing gets returned when I have an alert with expires date set to tomorrow. I tried greater than and lower than, both returned nothing.

[Nigel]

Hi Larry.

Types date fields are stored as UNIX timestamps, meaning they are NUMBERS, not DATES.

If you change the type to NUMBER it should work okay.

[larryB-3]

Thanks! That worked!