Order values within a custom data field | Community
Skip to main content
T
TraKill
New Participant
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

kautuk_sahni
kautuk_sahni
Employee
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
New Participant
July 29, 2025

Yes, I was, thank you!

    kautuk_sahni
    kautuk_sahni
    Employee
    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
    Srinija_N
    Srinija_N
    New Participant
    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
      New Participant
      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
        New Participant
        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. 

          Terms & ConditionsAccessibility statement

          Loading footer...