When exporting a BAQ to Excel the date formatting always shows T00:00:00, anyway to get this to not show upon export? I have 2 different date columns that I have been playing with and can’t seem to find the right format.
Thanks!
Dyan
Yeah its strange because if you do right click > copy all and then paste it into excel, the date format is correct. But if you do export to excel its not. I think its the difference between client and server side processing. I wish the export honored the format set in the dashboard but it just doesn’t. I think I tried to report this at one point but it wasn’t accepted. I will try to find it.
Hi Dylan,
We just encountered this. This spiceworks forum post helped solve it.
For whichever date field you want to modify you need to create a calculated field.
Change Data Type:
Format: x(10)
Expression: CONVERT(VARCHAR(10), table.field, 110)
For this example I used PartTran.TranDate, so the expression would be CONVERT(VARCHAR(10), PartTran.TranDate, 110)
Now you can see if comparing to the actual TranDate column that our calculated field is hyphen separated if we test the query.
When you export the query to excel even though the normal TranDate showed as a short date code it has the time stamp, but the new calculated field does not.
Hope this helps.
-Mack