DOB returns 0 for ages less than one year, how do I cange to 1?

[Natalie]

Converting DOBs to ages, but less than one year old returns 0 value. I need
it to return the value of 1. Help!

 

[Rick B]

I guess you could do an IIF statement to trick it, but the truth is that a
6-month old is NOT 1 years old. Using your logic, everyone from birth until
their second birthday would show "1". That does not seem right.

If you want to do it though, wrap your formula in an IIF statement that
returns "1" if the result is "0".

 

[Ofer Cohen]

Check this link on how to calculate the DOB, using Year's, month's, day's

http://www.mvps.org/access/datetime/date0001.htm

 

[Douglas J Steele]

That code will return 0 if the DOB is less than a year ago.

 

[John Vinson]

Converting DOBs to ages, but less than one year old returns 0 value. I need
it to return the value of 1. Help!

That is the correct answer.

A week-old baby is not a year old.

John W. Vinson[MVP]

 

[Ofer Cohen]

I ment with the use of the CalcAge Sub.