Prev topic /w matches: none
Next topic /w matches: none
Forum Home

Messages to Show:

Topic's Subject: General admin questions
R2's Subject: How do we migrate our group's people to PRESTO, and tell them about it?
R3's Subject: Why are the date/times in my report sorted out of order? Next Match 
From: PRESTO Team To: All Groups
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:

  1. 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!.
  2. 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.

Create Topic

R4's Subject: How do I make a report display only future schedule items?

Help

Opera House Ushers Group:   OHUG Home Page   Contact Us

(Powered by PRESTO Group & Event Manager  —   Help/Support   FAQ   Spread the Word)