|When you combine multiple things into one 1 column (say
!i.date!, !i.time!) a text sort is done —
meaning the values in the column are looked at from left to right.
Thus for example, Dec 27 sorts before Dec 8 because 2 is less than 8.
There are 2 ways around this:
- For schedule items, there is a field especially for this case, namely When Info.
In other words, replace !i.date!, !i.time! with !i.when!.
- More generally this is what the Sort On dropdown menu is for. If you
give the !i.date!, !i.time! column a Sort On of 2nd Value, and precede
it with a !i.date! column whose Sort On is Hidden,
both columns will sort numerically and you will get the desired result.