topic Re: How to get the table filter to use local time instead of UTC? in ArcGIS Online Questions

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

vanessagiles — Fri, 05 May 2017 02:07:12 GMT

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

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

KellyGerrow — Fri, 05 May 2017 19:10:59 GMT

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

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

vanessagiles — Sat, 06 May 2017 03:57:15 GMT

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.

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

KellyGerrow — Sat, 06 May 2017 16:28:21 GMT

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

-Kelly

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

vanessagiles — Sat, 06 May 2017 21:54:10 GMT

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

anything in the settings of any use.

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

KellyGerrow — Tue, 09 May 2017 23:11:27 GMT

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

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

vanessagiles — Tue, 09 May 2017 23:14:49 GMT

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

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

KellyGerrow — Tue, 09 May 2017 23:17:08 GMT

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

Thanks!

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

vanessagiles — Fri, 12 May 2017 04:02:24 GMT

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.