topic Re: arcgis online increases or decreases dates by one day in ArcGIS Online Developers Questions

arcgis online increases or decreases dates by one day

JoseSanchez — Fri, 13 Nov 2015 19:50:06 GMT

Hello everyone,

We have a web application developed with WebApp Builder and for all records with dates the display shows a date that increases or decreases by one the value that is stored in the feature class,

The format of the fields date are stored in an Oracle 11G database. The data is stored in a SDE 10.2. instance.

Is there any configuration or set up to avoid displaying the wrong date.

Please advise.

Thanks

Re: arcgis online increases or decreases dates by one day

RickeyFight — Fri, 13 Nov 2015 19:58:49 GMT

Jose,

Look at Roberts response.

Web App Builder Date Issue

Re: arcgis online increases or decreases dates by one day

JoseSanchez — Mon, 07 Dec 2015 14:10:58 GMT

We ran the following Oracle SQL code of the table:

update [table]

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

where [datefield] is not null;