Solved: Slice of Table Within 24 Hours - Page 2

Andrew_Ford2 · 10-07-2020 07:51 AM

Hello AppSheet Community,

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

The status field must equal “Open”
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.

Andrew_Ford2

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”)

View solution in original post