Re: determining age in peoplesoft query



Not sure about peoplesoft, but the formula to calculate age in an ACCESS
query (the topic of this newsgroup) is:

DateDiff("yyyy",[Birthdate],Date())+(Format([Birthdate],"mmdd")>Format(Date(),"mmdd"))


--
Rick B



<jazdwit07@xxxxxxx> wrote in message
news:1136303456.089416.105710@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> hi, is there an expression i can use in peoplesoft query to return the
> exact age of person using the Birthdate field? thanks.
>


.