Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MulliganWJ

    Crystal formula needed to calculate age at a certain date

    Just figured it out... I used the following: if Month({DOB Field})<7 then {AGE field} else ({AGE Field}-1) I used 7 because I was attempting to get the age as of June 30th THanks for the help!!! Wendy
  2. MulliganWJ

    Crystal formula needed to calculate age at a certain date

    Ok, so the formula on Ken Hamady's page reads as follows: DateVar Birth:= {ages.Birth}; // Replace this with your field for Date Of Birth DateVar Ann := {ages.DateAnn}; // Replace this with CurrentDate to get their age as of the time of the report...
  3. MulliganWJ

    Crystal formula needed to calculate age at a certain date

    Hi ~ I'm hoping someone can help me with a crystal reports formula... I need to calculate age as of 06/30/2011 and I cannot get the formula correct. Any help would be appreciated. Thank you. Wendy

Part and Inventory Search

Back
Top