Stuart McLachlan
stuart at lexacorp.com.pg
Sat Jan 7 00:39:24 CST 2006
On 6 Jan 2006 at 21:46, Joe Hecht wrote:
> Almost.
>
> DOB = 5/11/1940
>
> =DateDiff("yyyy", [DOB], Now())+ Int( Format(now(), "mmdd")
> returns 66
>
> =DateDiff("yyyy", [DOB], Now
>
> Returns 172
>
Int(Format(Now(),"mmdd") will return the number 107 at the moment (7 Jan),
or106 (6 Jan) for you. It would have returned the number 1231 at the end
of last month (31 Dec). Are you sure that's what you want?
--
Stuart