Date format in Analysis for Excel
Any ideas how I can change the format to a "real date format" ?
I have a query result in Analysis, showing some date fields (info object Data type DATS (8)) but I can't really use the result format as a date.
I can't, for instance, calculate number of days, since the filed is treated as a text field.
Any workarounds that coud be helpful ?