Forum Discussion
MarkShnier__You
Qrew Legend
6 years agoYou appear to have created a formula text field to calculate the words representing the Time of Day. or perhaps they are from a text multiple choice field.
You can either create a new formula field of type Time of Day with a formula of
ToTimeOfDay([my text time of day field])
or else convert your text field to a Time of Day field type.
Then they should sort correctly.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
You can either create a new formula field of type Time of Day with a formula of
ToTimeOfDay([my text time of day field])
or else convert your text field to a Time of Day field type.
Then they should sort correctly.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------