I am using this to export a view with list of dates. When I open it, Excel doe not recognize the date. Also when I change the cell properties in Excel. The date will not be seen as a date format. I have tried many formats, but none of them are recognized as a date.
Is there a format we can use so that Excel can see is as a date, so we can filter and sort the dates in Excel.
Or is there another solution?
Make a view of date fields and choose a date format.
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
The only way I found is to export as CSV and then, when opening the file, a dialog allow to set a format for each imported columns.
You can select the date columns and set the appropriate format.
Changing this issue over to a feature request, as there's presumably a way to export to Excel properly, and set the data type on columns as the data is exported so that it gets recognised as a proper date.