Filter records based on the time they were created

189
1
01-19-2021 01:45 AM
Jon_Tait
New Contributor II

Hi. I have a Survey123 used by the public to make complaints about noise from industry. I'm using that data to populate a dashboard so the enforcement officer can assess the results. The officer would like to only see those records created at nighttime (between 23:00 and 07:00). Is there a way to filter the records in the web map to show only those records?

I have a CreationDate filed which includes the time but I don't seem to be able to filter against this, only by the date they were created.

Thank you

Jon

Environmental Control Officer
East Riding of Yorkshire Council, UK
Tags (3)
0 Kudos
1 Reply
AngelaMarsh1
Esri Contributor

Hi Jon,

A screenshot of your attribute table structure, and your dashboard configuration of this service would help with troubleshooting. 

This should be a straight forward filter to apply, so it may require a bit of digging to figure out where the problem is 🙂  It could be that the field you want to filter on isnt the correct field type - id check first that this is a standard date field. Another option is to make this service time enabled, and register that field as a time enabled field.

 

Let me know how you go 🙂

 

 

Happy Mapping
0 Kudos