grouping birthdates

[3dthies]

I have all the birthdates of my clients and I want a report in which I can group the birthdates to day and month but not the year. How can I achieve that?

Thanks

 

[kskid]

create a formula

//@BMonthDay
totext({table.birthdate},"MM/dd"

Group on @BMonthDay

 

[trixiegrrl]

Make a formula with this:

global numbervar DOB := 
day({DATE_OF_BIRTH});
global numbervar MOB := 
month({DATE_OF_BIRTH});

totext(MOB,0) &"/" & totext(DOB,0)

then group by it.

 

[DataDog]

assuming that {yourbirthdate.field} is a date field...
@month formula:
month{yourbirthdate.field}

@day formula:
day{{yourbirthdate.field}

Group 1 @month formula
Group 2 @day formula

Also it would be nice in the future if you state your Version on Crystl, what db you're connecting to, etc.

DataDog
If God wanted us to count in Hexadecimal, then why did he only give us A fingers?