J Jim Allensworth Jan 4, 2004 #2 I would like to be able to calculate birthdate in a query Click to expand... Uhh, that's not a calculation. We are born when we are born. Although, some of us would like to advance that date at times ;-) - Jim Ok, maybe a little more info.
I would like to be able to calculate birthdate in a query Click to expand... Uhh, that's not a calculation. We are born when we are born. Although, some of us would like to advance that date at times ;-) - Jim Ok, maybe a little more info.
J John Vinson Jan 4, 2004 #3 I would like to be able to calculate birthdate in a query Click to expand... calculate it... from what? If you mean that you want to calculate this year's birthday anniversary date given a stored date of birth field in your table, you can use an expression: HappyHappy: DateSerial(Year(Date()), Month([DOB]), Day([DOB]))
I would like to be able to calculate birthdate in a query Click to expand... calculate it... from what? If you mean that you want to calculate this year's birthday anniversary date given a stored date of birth field in your table, you can use an expression: HappyHappy: DateSerial(Year(Date()), Month([DOB]), Day([DOB]))
