Showing posts with label How to calculate age in crystal report form date of birth. Show all posts
Showing posts with label How to calculate age in crystal report form date of birth. Show all posts

Friday, December 7, 2012

How to calculate age in Years,Months and Days crystal report form date of birth



Here DOB is Date of Birth.

Returns Year = DateDiff('yyyy',{DOB},CurrentDate())

Returns Months = DateDiff('m',{DOB},CurrentDate()) - (DateDiff('yyyy',{DOB},CurrentDate()) *12)

Returns Days =
DateDiff('d',{DOB},CurrentDate()) - ( (DateDiff('m',{DOB},CurrentDate()) / 12) * 365.25  )