CSViewer is not correctly sorting my dates in d-M-yyyy format
Tried to set a format to dd/MM/yyyy but this does not resolve the issue
Datatype is detected as all text (source is a .csv file)
@Paul_Verkooijen Column format only affects date and datetime values, stored as numbers (in the OLE Automation Date format). Since all the values in the TT_DATE column are text, they are sorted as text regardless of the chosen Column format.
Hi @andrew.rybka , I get that, only it’s an CSV file and cannot manipulate the content for viewing.
Excel has no issues detecting the date format
d-M-yyyy is a default for Europe, Asia. and a lot of other countries
So it would be great if CSViewer could be set to/detect more formats
1 Like
Note taken. The topic has been moved to Feature requests
As a workaround, you can use (the free edition of) EasyMorph Desktop to view the file. There, you can use the "Convert data type" action to convert text dates into number dates.
1 Like