I have a report that gets ran in CSV only and the end user wants the date format of yyyy-mm-dd. I have it set in SSRS and it works in every other format BUT csv. How can I get this date format to stick in csv without having to run it in excel and then save it as csv?
Try converting the field to text in SSRS.
1 Like
I did. And, it works for any other format, but csv. Which I find very weird.
Not really…
Scientists rename human genes to stop Microsoft Excel from misreading them as dates - The Verge
This is an Excel issue. All I can think you can do is run a macro that reformats the date after import. 
Try adding another field and put an expression in that takes the value of the text box and converts it to string.
Is it possible to change the date format in the baq? I see a date conversion option for year, month, day. However, I can’t get it to work on the date I need to change.
If I change the format in the BAQ, and then run it through SSRS, will the csv still mess it up?
Make a calculated field - of type text - in the BAQ, with the the date in the format you want. Then it’s just a string of numbers and dashes.
I’m assuming the CSV is to be used by some other system and not Excel.
