Forum Discussion
sort data by date
I need to sort my data of several columns using the date, when I download the Trading data it is in text form which does not help me. I need the date format to start with the year_month_day (1 to 3...
Most likely you "dates" are in fact text and need to be converted to real dates. Then you can sort them. Can you upload an example showing how the dowloaded data looks like?
Riny_van_Eekelenas I have already said in my previous message, I know that it is downloaded in text form and I have tried to change the format but the changes won't apply or stay.
I have attached a image or do you need a excel file example?
regards and thanks
A file example would helpful.
Riny_van_EekelenHello Riny, the example I sent to you, I already changed to a "date" format from the original General Text format. It still did not give me what I wanted.
regards and thanks
