How to get the table filter to use local time instead of UTC?

vanessagiles · ‎05-04-2017

I have a Web App set up with various table views available for my users to easily export the tabular data. This works fine except when you apply a date filter, the filter operates on UTC time instead of local time. Is there a way of fixing this?

visual example# attached - when I apply a date filter then I lose the first 10 hours of the day and get 10 hours of the following day.

TIA

KellyGerrow · ‎05-05-2017

When data is published as a hosted feature service, it is assumed that the date time is in utc. The application performs a date translation so it matches the appropriate date and time that matches your computer. If you have data that is collected in local time, you can set a timezone during publishing, from a csv or ArcGIS Pro, which will allow the server to understand that the date time data is in a local time zone, and will modify the data so it appears correctly.

Helpful links:

Work with fields—ArcGIS Online Help | ArcGIS (scroll to considerations with date fields)

Publish hosted feature layers—ArcGIS Online Help | ArcGIS

Configure service parameters—ArcGIS Pro | ArcGIS Desktop

-Kelly

vanessagiles · ‎05-05-2017

Thanks for your response Kelly. Actually my feature service was published via Survey123 so there was no opportunity to set the local time. Is there anyway to correct it now? The times display correctly in the attribute table but as I said, the filter reads it as UTC.

KellyGerrow · ‎05-06-2017

Which app are you using? It sounds like there may be a bug with the filter.

-Kelly

vanessagiles · ‎05-06-2017

It was built using the Web App Builder.. Does that help? I can't see

anything in the settings of any use.

KellyGerrow · ‎05-09-2017

Can you share your web map and app? If not, I suggest contacting technical support.

vanessagiles · ‎05-09-2017

I can't share it publicly. I have got someone from ESRI Australia looking into it now. Thanks!

KellyGerrow · ‎05-09-2017

Great. Please update the post once they have narrowed it down further!

Thanks!

vanessagiles · ‎05-11-2017

Hi, the answer is "There are actually a number of bugs that relate to UTC time being returned and their status is 'In Product Plan'. This doesn't really give us a time frame". So lets hope it happens sometime soon.