Forum Discussion

graham leo's avatar
graham leo
Copper Contributor
Jan 15, 2020

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...
excel
graham leo's avatar
graham leo
Copper Contributor
Jan 15, 2020

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

 

 
 
 
  • graham leo's avatar
    graham leo
    Copper Contributor
    Jan 15, 2020

    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

    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Jan 15, 2020

      graham leo 

      Noticed that some of the dates were already real dates. Inserted two columns with converted dates. It seems to be consistent with what you want to see. If not, let me know.

       

      Used "Text to columns" and converted the texts to dates as DMY, because that seems to be format your date texts are in. After that I reformated the dates as "yyyy/mm/dd hh:mm".

       

      • graham leo's avatar
        graham leo
        Copper Contributor
        Jan 16, 2020

        Hello Riny_van_Eekelen, this looks like a solution, thank you.

         

        Did you create the format yourself? 

         

        If so can you give a outline as to how you did it?

        I think I have an idea but it would be good from you to confirm it.

         

        regards Graham

Resources