Count Days

[thingsonline]

Hi .....
I need to calculate the days until a persons birthday. I have a field DOB (Date Of Birth), I have worked out (with much help) how to calculate the age of the person, but I now need to calculate the days until the persons birthday. Can anyone please help me ????

ThingsOnline

 

[marty1452]

Do you need to know the days until their birthday as in 321 days until their next birthday or is -7 days would tell you they had a birthday 7 days ago a 7 would mean a birthday is coming up in 7 days.

One method is look at the current month and day only and subtracting the birth month and day from it. Past the birthday is a negative number. Another is to look at the current month day and year and calculate the next birthday.

What are your needs?

Marty