Date to Age

Yahoo Archive
1
I think the following formula will give you exactly what you are looking
for.

I used the formula based on EmpBasic.Date01 being the B-Date. You
should be able to transpose this to work any field you want.



IIF (DateDiff ("d", Date (Year (Today), Month ({EmpBasic.Date01}), Day
({EmpBasic.Date01})), Today) > 0, DateDiff ("yyyy", {EmpBasic.Date01},
Today)-1, DateDiff ("yyyy", {EmpBasic.Date01}, Today))



Any problems (or explanations), feel free to contact me.

Aaron Hoyt

Hittite Microwave Corporation



-----Original Message-----
From: Gary Wassing [mailto:gwassing@...]
Sent: Friday, March 12, 2004 2:27 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Date to Age



Having difficulties using the datediff function in crystal. I want to
use
the birthdate field and create a formula of how old the person is. Can
someone help please.



--

Gary Wassing

MIS

SteelCraft Industries

519-271-4750 x227





[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links




_____

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> Service.



[Non-text portions of this message have been removed]
2
Having difficulties using the datediff function in crystal. I want to use
the birthdate field and create a formula of how old the person is. Can
someone help please.



--

Gary Wassing

MIS

SteelCraft Industries

519-271-4750 x227





[Non-text portions of this message have been removed]
3
If you are looking for # years as a whole #, use:
DateDiff ("yyyy",{EmpBasic.Date01} , CurrentDate)


If you are looking for an age not rounded you can use
(DateDiff ("d",{EmpBasic.Date01} , CurrentDate)) / 365.25
4
I believe the below should work:

(Currentdate - {BirthDateField}) = Number of days old.

Can then divide the above by 365 if years needed, etc.

Rick Lane, CIERP
Intelligent Systems Integration, Inc.
600 Weber Drive
Wadsworth, OH 44281
PH: 330-335-5291
FX: 330-335-7275
www.intelligentsi.com

"Helping Business Make Intelligent Use of Technology"


-----Original Message-----
From: Gary Wassing [mailto:gwassing@...]
Sent: Friday, March 12, 2004 2:27 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Date to Age


Having difficulties using the datediff function in crystal. I want to use
the birthdate field and create a formula of how old the person is. Can
someone help please.



--

Gary Wassing

MIS

SteelCraft Industries

519-271-4750 x227





[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links