var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Date (Month/Day) calculated from DOB
First time posting, avid reader.
I would like help with calculating a date based off a person's birthdate month/day, as a way to know when to order new documents on them.
Example, 3 months prior to someone's birthdate on the day and 6 months after the person's birthdate on the day.
3 mo prior: 3/1/2009
6 mo after: 12/1/2009
I calculate the person's age with the following:
I tried using the DateAdd function: DateAdd("m",6,[Birthdate])
Which works for Month and Day however not the year, because the result I'm looking for is when to order this year, when it calculates from the person's birth year.
Do I have to separate the birthdate field into month,day and year and go from there?
You can get their birthday for the current year as follows:
DateSerial(Year(Now), Month(Birthdate), Day(Birthdate))
Last edited by Ax238; 06-01-09 at 16:18.