Geoprocessing widget export csv - Date/Time issue

1129
1
Jump to solution
07-26-2016 09:26 AM
BrianLomas
Occasional Contributor III

When I export to a CSV from the geoprocessing widget my date field comes out very strange and will not format in excel. I attached a pic of the gdb file format and one of the excel format after the export through the gp widget. Any ideas on what is going on and how to fix it?

Tags (1)
0 Kudos
1 Solution

Accepted Solutions
RobertScheitlin__GISP
MVP Emeritus

Brain,

  The GP Widget is exporting the actual UTC date time number that is return from ArcGIS Server. Dates are handled as UTC by ArcGIS Server and the GP widget is just returning that actual value and not the client formatted string of the date. You wil need to log a bug/enhancement request for this.

View solution in original post

1 Reply
RobertScheitlin__GISP
MVP Emeritus

Brain,

  The GP Widget is exporting the actual UTC date time number that is return from ArcGIS Server. Dates are handled as UTC by ArcGIS Server and the GP widget is just returning that actual value and not the client formatted string of the date. You wil need to log a bug/enhancement request for this.