Forum -
I'm writing to CSV using generate macro timestamp (date_str_custom(date_now(),"yyyy-MM-dd")) and then write CSV to the below location. E %{timestamp}.csv
This gives me the correct file name I wish it to have i.e. E todays date (ex. E 2017-11-29)
So far so good, however, when i open the file he data and number fields are displayed as
11/29/2017 12:00:00 AM (i want it to only be displayed as 11/29/2017)
1944564.0 (I want it only to be displayed as 1944564)
If i write to Excel I have the option to specify date format (yyyy-MM-dd) and number format (#) and I would want the same functionality for CSV.files.
The reason I want it in CSV is becaused I'm running a process multiple times a day and need to upload this file into another system. Writing it to Excel and then convert it each time is manual and time consuming.
Any ideas?