August 30, 2008 02:18am pdt

1. b0lsc0tt 7,500
2. tedbilly 5,000
3. Merete 3,350
4. ina_don 3,080
5. apitbajpai 3,000
6. BongSoo 2,500
6. mark_wills 2,500
6. BillBach 2,500
9. chapmandew 2,050
10. TomasHelgi 2,000
10. meyersd 2,000
10. gtgloner 2,000
10. lherrou 2,000
10. SQL_SE... 2,000
10. neopolitan 2,000
10. syllatrexm 2,000
10. capricorn1 2,000
10. DanRollins 2,000
10. BillDL 2,000
10. LindaC 2,000
10. anand_2... 2,000
10. jvaldes 2,000
10. snagsy1... 2,000
10. clayfox 2,000
10. maxis2cute 2,000
10. vishal_im... 2,000
10. DanCh99 2,000
10. cocofalco 2,000
10. hielo 2,000
10. jimpen 2,000
10. jinesh_ka... 2,000
10. xpsavy 2,000
10. jamespfinn 2,000
10. TekServer 2,000
10. TommyTupa 2,000
10. dtodd 2,000

1. b0lsc0tt 9,500
2. SStroz 6,350
3. GLCompu... 5,675
4. tedbilly 5,000
5. itsmeandn... 3,500
6. ina_don 3,455
7. Merete 3,350
8. angelIII 3,000
8. apitbajpai 3,000
8. TommyTupa 3,000
11. BongSoo 2,500
11. BillBach 2,500
11. mark_wills 2,500
14. chapmandew 2,050
15. anand_2... 2,000
15. LindaC 2,000
15. dougcast... 2,000
15. jvaldes 2,000
15. maxis2cute 2,000
15. snagsy1... 2,000
15. humergu 2,000
15. SQL_SE... 2,000
15. teraplane 2,000
15. meyersd 2,000
15. faisalmalaeb 2,000
15. dtodd 2,000
15. capricorn1 2,000
15. cocofalco 2,000
15. hielo 2,000
15. Wizilling 2,000
15. BillDL 2,000
15. dovidmichel 2,000
15. DanRollins 2,000
15. TomasHelgi 2,000
15. blu 2,000
15. dqmq 2,000
15. LoNeRaV... 2,000
15. asian_nic... 2,000
15. ylandrum 2,000
15. realevergod 2,000
15. lherrou 2,000
15. todd5524 2,000
15. michko 2,000
15. DanCh99 2,000
15. andrewbl... 2,000
15. xpsavy 2,000
15. cgordon81 2,000
15. tbarbe01 2,000
15. computered 2,000
15. shuboarder 2,000
15. jamespfinn 2,000
15. clayfox 2,000
15. vishal_im... 2,000
15. lorenkoeman 2,000
15. TekServer 2,000
15. jimpen 2,000
15. grakem 2,000
15. Pricejr 2,000
15. syllatrexm 2,000
15. jinesh_ka... 2,000
15. neopolitan 2,000
15. seriousnick 2,000
15. warrenbu... 2,000
15. Arrow_1 2,000
15. gtgloner 2,000

11.13.2007 at 06:03AM PST, ID: 22957011

	[x] Attachment Details

Crystal Reports - Convert birthdate to age

Asked by byd2k in Software, Crystal Reports Software

Tags: age, crystal, reports, birthdate, convert

Hi Experts.

In a Crystal Report I have the raw data as: 20010101. I was able to create a formula to switch it around to: 01/01/2007. From either this field or the other, can anyone suggest on a method to compute the age from the birth date? I have found on other web sites how to do this with Excel using a formula similar to below.

Todays Date - Birth date / 365...

I would like Crystal to perform this functionality versus using Excel as a crutch. ;)

Thanks,
Byd2k

Souce: http://www.exceltip.com/st/Working_Out_a_Person's_Age_in_Microsoft_Excel/634.html

Start Free Trial

Keywords: Crystal Reports - Convert birthdate to …

	Title
1	Crystal Reports, 10, @Age Suppre…
2	Age formula
3	Crystal Reports, 9, Formula Assista…
4	Date of Birth Formula
5	The best age computation formula
6	Age calculation in form using DLookup

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Crystal Reports - Convert birthdate to age

Asked by byd2k in Software, Crystal Reports Software

Tags: age, crystal, reports, birthdate, convert

About this solution