topic Re: Web App Builder Date Issue in ArcGIS Web AppBuilder Questions

Web App Builder Date Issue

KarimNaguib — Thu, 05 Nov 2015 16:43:52 GMT

Good morning,

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?

Thank you.

Re: Web App Builder Date Issue

RobertScheitlin__GISP — Thu, 05 Nov 2015 17:30:48 GMT

Karim

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.

Re: Web App Builder Date Issue

KarimNaguib — Thu, 05 Nov 2015 18:35:29 GMT

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.

Re: Web App Builder Date Issue

JoseSanchez — Fri, 13 Nov 2015 20:43:12 GMT

Hello, we have the same problem here.

how can we initialize only the hour part of a date, for example at 8:00 a.m.

Are there other solutions?

Thanks

Re: Web App Builder Date Issue

RobertScheitlin__GISP — Fri, 13 Nov 2015 20:46:28 GMT

Jose,

You just do a field calculation to concatenate the time portion to the date field.

Re: Web App Builder Date Issue

KarlKeough1 — Mon, 23 Nov 2015 17:45:39 GMT

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?

Thanks,

Karl

Re: Web App Builder Date Issue

JoseSanchez — Mon, 23 Nov 2015 17:56:21 GMT

We fixed the problem running an Update query directly in Oracle and adding the time

update tableT

set
FieldWithDate =
to_date(TO_CHAR(FieldWithDate,'dd-mm-yyyy') ||' 06:00:00',
'dd-mm-yyyy hh24:mi:ss')

where FieldWithDate is not null;

Re: Web App Builder Date Issue

SteveXu — Wed, 22 Nov 2017 16:30:24 GMT

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?

Thank you!

Re: Web App Builder Date Issue

RobertScheitlin__GISP — Wed, 22 Nov 2017 16:38:53 GMT

Steve are the records that are having the issues ones that do not have a time in the date?

Re: Web App Builder Date Issue

SteveXu — Wed, 22 Nov 2017 18:30:17 GMT

Hi Robert:

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 Starts: 11/9/2017, 7:00 AM, which should show Starts: 11/9/2017, 8:00 AM. The same to Ends in the popup, the popu shows Ends 11/10/2017 5:00:00 PM, which should be Ends: 11/10/2017, 6:00 PM.

Please let me know if I made my issue clear.

Thank you very much for looking into this issue.

Re: Web App Builder Date Issue

RobertScheitlin__GISP — Wed, 22 Nov 2017 18:58:54 GMT

Steve,

I am not real sure as to what is going on them.

Re: Web App Builder Date Issue

SteveXu — Wed, 22 Nov 2017 23:56:02 GMT

Robert: I have created the case with ESRI Canada Support, and hope they can help. Thank you.

Re: Web App Builder Date Issue

SteveXu — Fri, 24 Nov 2017 20:40:31 GMT

I'd like to update my solution to the issue.

Based on another post at https://community.esri.com/thread/91407, in which someone mentioned to use string date time. I tested, and found that using string date time is the simple good solution to my project.

Another solution is still using data time fields, which will be automatcally ajusted by ArcGIS Online web. In order to resolve the data time differences when the public sees on the ArcGIS online web, we have to update those data time values in the 2 date time fields based on MST and MDT (I'm located in Mountain time zone), which will resolve the issue in my original post.