Hello,
I want to filter rows based on the last 24 hours. I can currently filter rows by matching dates but I quickly realized in the early parts of the day (for example 12am) no data will show.
Is this possible to accomplish? Thank you for your time!
Figured it out! For anyone wondering, I used ‘Compare Dates’ and formatted all dates using ‘Format Dates’. Changed all current dates to show hours. Then used an If/Else against the current time to only show hours less than 24.
3 Likes