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

[Nijs_Gold_23]

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]

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.