Order values within a custom data field

[TraKill]

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

[Srinija_N]

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!

[TraKill]

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 · Accepted solution]

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]

@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!

[TraKill]

Yes, I was, thank you!

[kautuk_sahni]

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