Date Order Script

[Constanza]

Dears, 

Please your help. I have an excel file with many entries, one of them is the date and I need to order them from the oldest to the newest. 

Is there any possibility to do this in the script? This because then I need the value order to continue editing. 

Best regards 

Constanza 

[Patricia_Silva]

Hello @Constanza I think you could achieve this by using order by in your load script. Here are some useful link that could help you solve what you need to achieve: 

https://community.qlik.com/t5/QlikView-App-Dev/sort-dates-in-script/td-p/50244

https://community.qlik.com/t5/QlikView-App-Dev/Date-sort-nor-working-in-script/td-p/1125337

If I am not wrong you would need also to specify if you want the order ascending or descending:

Order By FieldName asc;

Hope this could help you!