Happy Coding

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  )
Posted by Imran Sarwar at 3:17 AM 2 comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: age in Years, Calculate age in Cryral report., How to calculate age in crystal report form date of birth, Months and Days crystal report
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Blog Archive

  • ►  2018 (1)
    • ►  March (1)
  • ►  2015 (1)
    • ►  March (1)
  • ►  2014 (3)
    • ►  November (1)
    • ►  October (1)
    • ►  September (1)
  • ▼  2012 (7)
    • ▼  December (1)
      • How to calculate age in Years,Months and Days crys...
    • ►  October (4)
    • ►  September (1)
    • ►  August (1)

Contributors

  • Imran Sarwar
  • Unknown
Simple theme. Powered by Blogger.