User Support Forum

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?

Thanks,

Carl

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.