DOB

[user222]

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

using

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

 

[bborissov]

Convert it to integer.

CAST(((Now())-([DOB]))/364 as integer)
-- or
Convert(int,((Now())-([DOB]))/364)

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.

 

[user222]

just tried both these on my access form and I get (VALUE??)

 

[macleod1021]

Access doesn't allow the same commands as SQL, you should ask this in the Access forum.

 

[spizotfl]

in vba to cast to an int use CInt()

"Maturity is a bitter disappointment for which no remedy exists, unless laughter can be said to remedy anything."
-Vonnegut

 

[user222]

thank you all. I have sorted it by using

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

 

[SQLBill]

Glad you solved it, but you do need to post in the proper forum. This is for Microsoft's SQL Server.

-SQLBill

Posting advice: FAQ481-4875