0

Order by date from text field

Hi. I have a date in text field and I want to order it by date. Create a date field is not an option, I need it to be with this text field. Is there any way to do that? Maybe a formula field that loads the date in format DD/MM/YYYY?

Thanks.

3 replies

null
    • Fred
    • 1 yr ago
    • Reported - view

    I would agree that you need a new formula field that converts the data in the text field into a date format.

    I hope your data is in a consistent format in the text field. That will make the conversion easier.

    There are a few ways to split the text into year/month/day and then join them back together.

    One way is to use the split function to convert the data into an array then use the index function within a date function to re-create the date.

    Another is to use the substring function in three variable to separate the data then use the date function to re-create.

    Or you can use the extractx function in three variable to separate the data then use the date function to re-create.

      • FAIB
      • Mateo_Dominguez_Fuentes
      • 1 yr ago
      • Reported - view

      Fred how can I do what are you suggesting?

    • FAIB
    • Mateo_Dominguez_Fuentes
    • 1 yr ago
    • Reported - view

Content aside

  • Status Answered
  • 1 yr agoLast active
  • 3Replies
  • 122Views
  • 2 Following