Can I create function for calculate age ?

Can I create function for calculate age ?
example
Mr x. was born on 27/JAN/1976
now he is 24 years 3 months and 28 days

Thank you
Matty

Is this your high school assignment?



Matty <yutthasak@bangkokair.co.th> wrote in message
news:390935f4$1@news.devx.com...
>
> Can I create function for calculate age ?
> example
> Mr x. was born on 27/JAN/1976
> now he is 24 years 3 months and 28 days
>
> Thank you
> Matty

Short answer:- Yes, you can.

"Matty" <yutthasak@bangkokair.co.th> wrote in message
news:390935f4$1@news.devx.com...
>
> Can I create function for calculate age ?
> example
> Mr x. was born on 27/JAN/1976
> now he is 24 years 3 months and 28 days
>
> Thank you
> Matty

More precisely: Yes, WE can. Obviously, he can't.

"Michael Cole" <mc@mercsys.com.au> wrote:
>Short answer:- Yes, you can.
>
>"Matty" <yutthasak@bangkokair.co.th> wrote in message
>news:390935f4$1@news.devx.com...
>>
>> Can I create function for calculate age ?
>> example
>> Mr x. was born on 27/JAN/1976
>> now he is 24 years 3 months and 28 days
>>
>> Thank you
>> Matty
>
>

"Gary Choma" <gchoma@invtitle.com> wrote:
>
>More precisely: Yes, WE can. Obviously, he can't.
>
>"Michael Cole" <mc@mercsys.com.au> wrote:
>>Short answer:- Yes, you can.
>>
>>"Matty" <yutthasak@bangkokair.co.th> wrote in message
>>news:390935f4$1@news.devx.com...
>>>
>>> Can I create function for calculate age ?
>>> example
>>> Mr x. was born on 27/JAN/1976
>>> now he is 24 years 3 months and 28 days
>>>
>>> Thank you
>>> Matty
>>
>>
>

Jeez guys, give the guy a break. He's obviously here looking for some help,
not to get flamed.

Matty,
Take a look at the DateDiff and DateSerial functions.

Hope this helps,
-Russ.

Even better, check out the first entry in the Date/Time section of Dev
Ashish's "The Access Web" http://www.mvps.org/access/

--

Doug Steele, Microsoft Access MVP
Beer, Wine and Database Programming. What could be better?
Visit "Doug Steele's Beer and Programming Emporium"
http://I.Am/DougSteele/


Russ <russell.thompson@adlink.com> wrote in message
news:3909ae59$1@news.devx.com...
>
> "Gary Choma" <gchoma@invtitle.com> wrote:
> >
> >More precisely: Yes, WE can. Obviously, he can't.
> >
> >"Michael Cole" <mc@mercsys.com.au> wrote:
> >>Short answer:- Yes, you can.
> >>
> >>"Matty" <yutthasak@bangkokair.co.th> wrote in message
> >>news:390935f4$1@news.devx.com...
> >>>
> >>> Can I create function for calculate age ?
> >>> example
> >>> Mr x. was born on 27/JAN/1976
> >>> now he is 24 years 3 months and 28 days
> >>>
> >>> Thank you
> >>> Matty
> >>
> >>
> >
>
> Jeez guys, give the guy a break. He's obviously here looking for some
help,
> not to get flamed.
>
> Matty,
> Take a look at the DateDiff and DateSerial functions.
>
> Hope this helps,
> -Russ.
>
>
>
>