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?
Solved! Go to Solution.
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.
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.