Slice of Table Within 24 Hours

[Andrew_Ford2]

Hello AppSheet Community,

I need to create a slice of a table incidents with two conditions.

1. The status field must equal “Open”
2. The submissionDate field must be within 24 hours of the current time.

I made submissionDate a date&time field. I know I start the slice with [Incident Status]=“Open” but I’m not sure how to filter the submissionDate to a rolling 24 hour of current time.

[Suvrutt_Gurjar]

Please try with NOW()-1

AND( [Incident Status]=“Open” , [SubmissionDate]>= (NOW()-1) )

However , I believe such a slice will update to show the correct records in the past 24 hours from the current time , only as and when the app syncs.

[Andrew_Ford2]

Doesn’t seem to be working. I added a new incident then refreshed the app and the slice doesn’t seem to appear on the menu anymore.

[Andrew_Ford2 · Accepted solution]

Did a little fiddling and now it works. Not sure why, but altering the formula to this made it work:
AND([SubmissionDate]>= NOW()-1,[Incident Status]=“Open”)

[Suvrutt_Gurjar]

Great. Nice to know you got it working.

My testing on an exactly similar set up showed that it works well with originally suggested expression format as well.