arcgis online increases or decreases dates by one day

[JoseSanchez]

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

.

[RickeyFight]

Jose,

Look at Roberts response.

Web App Builder Date Issue

[JoseSanchez · Accepted solution]

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;