Filter records based on the time they were created

[Jon_Tait]

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

[Anonymous User]

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 🙂