Order values within a custom data field | Community
Skip to main content
T
TraKill
Level 3
May 28, 2025
Solved

Order values within a custom data field

  • May 28, 2025
  • 2 replies
  • 471 views

Hi,
I am looking for a (text mode) option to sort a field that includes dates and times, but is a text field:

 

June 1 - 8:00

June 1 - 9:00

June 2 - 8:00

June 2 - 9:00

 

Is there a way?

 

Thanks in advance

Best answer by SuryaLakhani

You could use the DATE() function to convert the text field to a date. If this does not work directly at the report level, you could create a calculated date field using the function on the same form. 

2 replies

Srinija_N
Srinija_N
Level 7
May 29, 2025

This might help you to sort your column on a report. Let us know if your need is something else.

 

querysort=DE:field_name

sortOrder=1

sortType=asc

 

 

Please mark my response as "Correct reply" if this helped you and to help others.

Thanks in advance!

    T
    TraKillAuthor
    Level 3
    May 29, 2025

    No, that is the problem as I mentioned i think due to it being a TEXT field this text mode is not working. I receive the following error message: customdata.text.cantsort

      SuryaLakhani
      SuryaLakhaniAccepted solution
      Level 4
      June 4, 2025

      You could use the DATE() function to convert the text field to a date. If this does not work directly at the report level, you could create a calculated date field using the function on the same form. 

        kautuk_sahni
        Community Manager
        kautuk_sahniCommunity Manager
        Community Manager
        July 16, 2025

        @trakill Just checking in — were you able to resolve your issue?
        We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could really benefit the community. Thanks again for being part of the conversation!

        Kautuk Sahni
        T
        TraKillAuthor
        Level 3
        July 29, 2025

        Yes, I was, thank you!

          kautuk_sahni
          Community Manager
          kautuk_sahniCommunity Manager
          Community Manager
          July 30, 2025

          @trakill Great, that it’s working now! Would you mind sharing how you fixed it? It might be helpful for others down the line.

          Kautuk Sahni
          Terms & ConditionsAccessibility statement

          Loading footer...