Crystal Reports 8.5 first day of year function

[cousinconley]

I am trying to figure out how to do a datediff calculation using a persons birthdate and first day of the year. I do not want to hardcode 01/01/2006. If I hardcoded I would have to update the report formula every year. This is what I have so far:

numbervar Age:= DateDiff("YYYY",{PS_PERSON.BIRTHDATE} , CurrentDate);

I have tried doing some different things with current date by using the year function and trying to concatenate 01/01/ but so far no luck. Any suggestions?

Thanks, Richard

 

[cousinconley]

Got it figured out:

numbervar firstday:= 01;
numbervar firstmonth:= 01;
numbervar currentyear:= year(CurrentDate);
datevar begofyear:= CDate(currentyear,firstmonth,firstday);

numbervar Age:= DateDiff("YYYY",{PS_PERSON.BIRTHDATE} , begofyear);