# CSViewer sorting issue with text dates

**URL:** <https://community.easymorph.com/t/csviewer-sorting-issue-with-text-dates/6459>\
**Category:** Feature requests\
**Created:** [November 11, 2025, 3:09pm UTC](https://community.easymorph.com/t/csviewer-sorting-issue-with-text-dates/6459 "2025-11-11T15:09:36Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Paul\_Verkooijen](https://community.easymorph.com/user_avatar/community.easymorph.com/paul_verkooijen/32/6548_2.png) [@Paul\_Verkooijen](https://community.easymorph.com/u/Paul_Verkooijen)\
**Post date:** [November 11, 2025, 3:09pm UTC](https://community.easymorph.com/t/csviewer-sorting-issue-with-text-dates/6459/1 "2025-11-11T15:09:36Z")

</div>

CSViewer is not correctly sorting my dates in d-M-yyyy format

 ![image](https://community.easymorph.com/uploads/default/original/2X/f/f82e74865e9951b0726f602abea714f43bce70e6.png)

Tried to set a format to dd/MM/yyyy but this does not resolve the issue

![image](https://community.easymorph.com/uploads/default/original/2X/6/67803d9e76ea1c2e37ca9b87b78eadf7e317e4d6.png)

Datatype is detected as all text (source is a .csv file)

 ![image](https://community.easymorph.com/uploads/default/original/2X/9/9ad358d9ad8b8731784b27e9edef61e3fa66516a.png)

---

<div class="post-metadata">

**Author:** ![andrew.rybka](https://community.easymorph.com/user_avatar/community.easymorph.com/andrew.rybka/32/13_2.png) [@andrew.rybka](https://community.easymorph.com/u/andrew.rybka)\
**Post date:** [November 11, 2025, 5:42pm UTC](https://community.easymorph.com/t/csviewer-sorting-issue-with-text-dates/6459/2 "2025-11-11T17:42:40Z")

</div>

@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.

---

<div class="post-metadata">

**Author:** ![Paul\_Verkooijen](https://community.easymorph.com/user_avatar/community.easymorph.com/paul_verkooijen/32/6548_2.png) [@Paul\_Verkooijen](https://community.easymorph.com/u/Paul_Verkooijen)\
**Post date:** [November 14, 2025, 6:35am UTC](https://community.easymorph.com/t/csviewer-sorting-issue-with-text-dates/6459/3 "2025-11-14T06:35:09Z")

</div>

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

 ![image](https://community.easymorph.com/uploads/default/original/2X/b/ba4de4cf85889f79853635ee99e402cbfcf2ab10.png)

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

 ![image](https://community.easymorph.com/uploads/default/original/2X/2/21e8678c6cb7208e634d531af5e70c13f57f0d33.png)

---

<div class="post-metadata">

**Author:** ![dgudkov](https://community.easymorph.com/user_avatar/community.easymorph.com/dgudkov/32/5_2.png) [@dgudkov](https://community.easymorph.com/u/dgudkov)\
**Post date:** [November 14, 2025, 9:55pm UTC](https://community.easymorph.com/t/csviewer-sorting-issue-with-text-dates/6459/4 "2025-11-14T21:55:35Z")

</div>

Note taken. The topic has been moved to #Feature requests

As a workaround, you can use (the free edition of) [EasyMorph Desktop](https://easymorph.com/download.html) to view the file. There, you can use the ["Convert data type" action](https://help.easymorph.com/doku.php?id=transformations:convert) to convert text dates into number dates.