Prev: new navigation control Access 2010beta
Next: Textbox Character Counter
From: John W. Vinson on 21 Jan 2010 00:48
On Wed, 20 Jan 2010 21:13:30 -0500, "Biss" <raleygroupky(a)hotmail.com> wrote:

>But It stills returns wrong age..
>
>DOB of 07-Jun-85 I get 25 years old.

<blush> Silly error on my part - should be > not <:

=DateDiff("yyyy", [DOB], Date()) -
IIF(Format([DOB], "mmdd") > Format(Date(), "mmdd"), 1, 0)

--

John W. Vinson [MVP]
From: Biss on 21 Jan 2010 10:04
John..

Many thanks for your patience..

Bob

Many thanks for all of your patience

"John W. Vinson" <jvinson(a)STOP_SPAM.WysardOfInfo.com> wrote in message
news:bkqfl51scmmsbkfa4v0v5hb7s8gng6ton6(a)4ax.com...
> On Wed, 20 Jan 2010 21:13:30 -0500, "Biss" <raleygroupky(a)hotmail.com>
> wrote:
>
>>But It stills returns wrong age..
>>
>>DOB of 07-Jun-85 I get 25 years old.
>
> <blush> Silly error on my part - should be > not <:
>
> =DateDiff("yyyy", [DOB], Date()) -
> IIF(Format([DOB], "mmdd") > Format(Date(), "mmdd"), 1, 0)
>
> --
>
> John W. Vinson [MVP]

First  |  Prev  | 
Pages: 1 2 3
Prev: new navigation control Access 2010beta
Next: Textbox Character Counter