access form calculate dob

[user222]

trying to calculate DOB with no decimal place but its showing the decimal places. can anyone help?

using

=((Now())-([DOB]))/364

 

[jkl0]

Try this.

=Int (((Now())-([DOB]))/364)

 

[JerryKlmns]

=DateDiff("yyyy", [DOB], Date)

 

[user222]

thanx for the help jk10 worked a treat!

 

[JerryKlmns]

How come you two, have 364 days in every year?

DateDiff("d", "2006-01-01", "2007-01-01") = 365
DateDiff("d", "2004-01-01", "2005-01-01") = 366

 

[Golom]

If you're trying to compute an age in years then you need something like

Age = DateDiff("yyyy", dd, Date) + _
      ((Format(dd, "mmdd") > Format(Date, "mmdd")))

Something like

Int((#05/25/2006# - #05/26/2000#) / 364) = 6

but the correct age is 5.

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]