Answer Question
Date Formatting
Hi,
We have tables and charts which contain date fields from SQL Server in the data source. Currently when downloading the chart from the dashboard view to CSV this exports the date correctly as a date format, however when exporting to Excel this field exports as a text field and therefore filtering and sorting in excel doesn't really work without converting all of the columns.
I have tried in the data source so cast the field and convert to different formats but this still seems to export to excel as a text field.
The ideal scenario is that in PI the date will show in tables and on charts in the format dd/MM/yyyy without a time element, however when exported to excel this column is exported as a date field type. Please can you advise the best way to do this?
Thank you
We have tables and charts which contain date fields from SQL Server in the data source. Currently when downloading the chart from the dashboard view to CSV this exports the date correctly as a date format, however when exporting to Excel this field exports as a text field and therefore filtering and sorting in excel doesn't really work without converting all of the columns.
I have tried in the data source so cast the field and convert to different formats but this still seems to export to excel as a text field.
The ideal scenario is that in PI the date will show in tables and on charts in the format dd/MM/yyyy without a time element, however when exported to excel this column is exported as a date field type. Please can you advise the best way to do this?
Thank you