Say "SEP-11", becomes "11-SEP "
To fix it, go to column properties for the specific date field and add a custom CSS Style sheet like " mso-number-format:\@"
Wednesday, October 5, 2011
OBIEE - Date Format issue When downloading to Excel Spreadsheet
when Excel sees a date value in a field, it overrides the value and converts it to a native date format automatically.
Say "SEP-11", becomes "11-SEP "
To fix it, go to column properties for the specific date field and add a custom CSS Style sheet like " mso-number-format:\@"
Say "SEP-11", becomes "11-SEP "
To fix it, go to column properties for the specific date field and add a custom CSS Style sheet like " mso-number-format:\@"
Subscribe to:
Posts (Atom)
