A have a straight table where one of the dimensions is =v_Date, where v_Date is 11/10/2018
QV treats it as a date and I'm happy with it.
But when I try to export the table to the excel, it shows value as a number.
each time QV shows me the correct date but when I export to excel - the same results - number and "General" as a format of the dimension.
I explicitly corrected it to text: =Text(v_Date) and changed Presentation >> Alignment >> Data(Text) to left. At least it still looks as "date" in QV and looks similar in Excel.
Although the format of the dimension in excel of course General.
How can I export a table with calculated dimension to excel without losing Date format?
maybe try specifying the format in QV.
Date(v_Date,'MM/DD/YYYY') - or whatever your format is.
could you attach an example QVW if it doesn't work?
Please find an example.
If you export the table to excel you will see the difference between the fields.
Even if I apply date() to a field that already is date - the excel results will be different.
that's the point. The only first column is treated by excel as a date.
But I need to get a date format for columns with calculated dimensions
I think it could be a bug because if you right click in the table and copy full table, then paste into excel, the formats are correct, so it looks like its just an export issue.