Moderators: Moderators, Tech Support
- Posts: 16
- Joined: Sat Feb 07, 2009 1:14 pm
I am trying to sort birthdays where the year has been truncated. The memory variable is as follows:
m.short_Bday = SUBSTR(DTOC(born),1,5)
Is it possible to sort by this variable?
- Tech Support
- Posts: 2652
- Joined: Thu May 13, 2004 8:59 am
- Location: PowerChurch Software
It is not possible to sort by a variable.
In the sort options on the report, you can only choose from your existing output fields, in Ascending (default) or Descending order.