Filtering Constraints: Created in the last 24 hours filter

[mjk]

Hi Guys,

I have spent some time going through the forum looking over the various options to help me filter a search by its creation date “within the past 24 hours”.

A useful post showed logic on how to filter search by created date for a future time. IE at midnight.

my constraint is trying to filter by a date in the past. so using the opposite logic to above i tried this

However I haven’t had any luck! Could anyone suggest what I am doing wrong? or alternatively a better option to filter data by “displaying data that was created within the past 24 hours”

Thanks!

[J805]

@mjk

Dates are always confusing, I know. Hope that I can help a little bit.

I think it should work if you do this:

Created Date > Current date/time +(days) -1

Hope that helps!

@j805 www.NoCodeMinute.com

For All Your No-Code Education Needs:

• One-on-One Tutoring
• eLearning Hub
• Video Tutorials
• No-Code Classes

[mjk]

Fantastic that worked a treat, thank you!

[J805]

Glad it helped!