So I have a report, and it involves an attribute for recurring deadlines for foundations. Since the attribute description is in the format MM/DD, a fuzzy date wouldn't work for them. I want to sort on the day. I already have a formula that figures out the month and compares it to the date fields from a parameter field, so that's good.

I created this formula and grouped on it:



(I have to use the numerictext function, because a few of the entries in the field are things like 'None' or 'Rolling Deadline' -- I only want to pull out the MM/DD entries)

However, this still won't sort by that field. Anyone have any ideas on what I might do to make it sort?

So I have a report, and it involves an attribute for recurring deadlines for foundations. Since the attribute description is in the format MM/DD, a fuzzy date wouldn't work for them. I want to sort on the day. I already have a formula that figures out the month and compares it to the date fields from a parameter field, so that's good.

I created this formula and grouped on it:



(I have to use the numerictext function, because a few of the entries in the field are things like 'None' or 'Rolling Deadline' -- I only want to pull out the MM/DD entries)

However, this still won't sort by that field. Anyone have any ideas on what I might do to make it sort?

Hi, I have a monthly birthday report where the same problem existed. Someone at Blackbaud gave me this formula, which extracts the day from the birthdate field:

If IsDate({CnBio.CnBio_Birth_date}) then
Day(CDate({CnBio.CnBio_Birth_date}))

I placed this in the detail section, suppressed it, and sorted on it. It works.

thanks jgsam! I never followed up -- it turned out I was having a brain fart, because I was grouping by sortkey first, and THEN by my date formula. so of course it was forcing it to be alpha! swapped the groups and I was good to go.