DataTableToCsv Weird Outputs

Permanently deleted user

March 03, 2017 14:38

Afte extracting data with the SQLQuery activity, I convert the output the datatable to a csv string with the datatable to csv activity. But when I see the output, the date field has totally changed formats. How do you retain the date format in the output text file?

 

 

 

 

 

0

• 

  Permanently deleted user

  March 03, 2017 15:34

  The output of the .csv can be controlled by going back to the sql statement used and format the date there.

   

  Walter

  0

Please sign in to leave a comment.