My “time” field refuses to sort correctly. Both ascending and descending present themselves randomly. Any ideas…
Just to feed back… Changed the field to “Date & Time” and the field sorts itself chronologically perfectly.
It’s because Time fields actually include a date part which affects sorting. The time values are really just Date & Time fields but don’t display the date portion. But behind the scenes they are full date objects.
I’ve set my time and date field to display the day of the week (i.e., “Wednesday, mmm dd, yyyy”) and I now find that the sorting for the date field is done alphabetically instead of chronologically. TapForms 5.1.4, the most recent my Mac can run. Have I missed a solution for this somewhere?
Hi Christopher,
Hmm… It really shouldn’t matter what the date format is that’s used to display the dates. It shouldn’t affect the sorting. Unless you used the DATE() function in a Calculation field and you were trying to sort on that. In that case the date is returned as a Text value and then it would sort alphabetically.
.
