Hi,
I want to display a date value in YYYY-MM-DD format in a csv template. I used SQL passthrough where I formatted the date fields values in YYYY-MM-DD format and trying to display in the report.
In excel it is working fine but when i display it in csv, the date values are shown in dd/mm/yyyy format.
Can anyone suggest how to display it in YYYY-MM-DD format in a csv report.

Many Thanks.

This message has been edited. Last edited by: <Emily McAllister>,

Since that is for a CSV file, have you tried to have it converted as a text instead of a date ?

You can use

newdate /A10 = FPRINT(<yourdate>, '<yourdatefmt>, 'A10');