Yesterday it was brought to my attention that the dates displayed in the pop-up window of a web app we have are consistently 1 day off the actual date in the feature class. As an example, I look at the data using desktop, and in the attribute table, it will show 7/1/2015. If I then go to the web app, and click on the same feature class, the pop-up window will show a date of 6/31/15. This is consistent across all 25,000+ records in the feature class.
Has anyone seen anything like this working with Web App Builder? If so, do you have a fix/work-around that you can share?
Sure this is a common issue when your date data was not entered with a time portion midnight is used for the time and ArcGIS server stores dates in UTC and what happen is WAB automatically adjust the UTC date for the client machines time zone and you end up having a date that is one day earlier after the time zone adjustment. The fix is to add a true time entry for all your data date field or just do a field calculation to set all your dates time portion to be 6 am.
Thanks Robert, that makes a whole lot of sense. Now I just need to figure out a way to update that regularly after the users enter the dates. I appreciate your quick feedback.
If we concatenate, is the original full date still maintained? I woild like to select records based on whether they are before or after another date in the table. Will concatenating do this selection based on the original full date or the concatenated date?
Also, I have a date field that is populated using ArcGIS Collector and another date field that is populated by editing within ArcGIS Online. The Collector date shows the full date, the AGOL date appears to be set to midnight, regardless of the time of day of the edit. I would like to format the AGOL date to show the date and time. How can that be done?
We fixed the problem running an Update query directly in Oracle and adding the time
to_date(TO_CHAR(FieldWithDate,'dd-mm-yyyy') ||' 06:00:00',
where FieldWithDate is not null;
ArcGIS server 10.4.1, host our map services
ArcGIS online Web Builder website. Create Web applications.
Feature classes are stored in our geodatabase (Oracle11gR2, ArcGIS 10.2)
I have a road closure dataset in which I have 3 feature classes: Road Closure points, road closure(line), and Road detours (line).
In all 3 layers, based on the post, 4 fields: MHStart, MHEnd, Starts, and Ends are created:
MHStart and MHEnd represent our local time (The Mountain Time Zone).
In order for ArcGIS Online Web Builder website to show the correct time (our local time), date values in Starts and Ends are used, which are equal to values in MHStart and MHEnd plus 6 hours.
On the online Web builder website, most of them can show correct data and time. However, some of them (2 of 16 records) show their time one hour behind:
Their data time should be:
Starts: 11/9/2017, 8:00 AM
Ends: 11/10/2017, 6:00 PM
Why does this happen? Would you please help?
No, the two records in this example are both have time in their dates.
In my original case details above, MHStart=11/9/2017 8:00:00 AM, Starts = 11/9/2017 8:00:00 AM plus 6 hours (I have a program to update starts and ends) =11/9/2017 2:00:00 PM, the value of starts is used in the popup of the ArcGIS online Web map, the popup shows