• Govindan kullan
    July 27, 2016 at 8:32 am #2347

    I am  getting incorrect date in Data Export  file.  I have a table in the coach view and added Data Export control to export the table data to file ,seeing the date is pervious date of in the table.   the date in the table is 07/25/2016 but in the exported file is showing 7/24/2016.

    SPARK Support
    July 27, 2016 at 2:40 pm #2351

    Hi Govindan,

    This is a known issue.  The System Date variable stored in the database is displaying in the browser as 7/25/2016 based on your location in relation to the Time Meridian.  The same stored datetime would show 7/24/2016 in my browser based on my location in the Pacific Standard Time zone.

    In order to actually store 7/25/2016, you need to capture the toString() output of the date, concatenate the date portion, and save the Business Data as a string.

    See this IBM article about how WebSphere uses GMT, and the solution is to use a custom data handler:

    http://www-01.ibm.com/support/docview.wss?uid=swg21503646

    Regards,

    Stephen P.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.

Start typing and press Enter to search