Skip to main content
T
TraKill
Level 3
May 28, 2025
Solved

Order values within a custom data field

  • May 28, 2025
  • 2 replies
  • 483 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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
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!

If this helped to solve your problem, please mark it as 'solved' so others can also find the solution faster. Thanks!
    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
        Adobe Employee
        kautuk_sahniAdobe Employee
        Adobe 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
        Level 3
        July 29, 2025

        Yes, I was, thank you!

          kautuk_sahni
          Adobe Employee
          kautuk_sahniAdobe Employee
          Adobe 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
          Terms & ConditionsAccessibility statement

          Loading footer...