G
Guest
After entering into the control source for age the following,
=DiffDates("ym",[BIRTHDATE],Now()) my report shows age in Years and months
i.e. 4 years 25 months. I would like display the age in short form like 4Y
25 M. How do I go about this? Kindly help.
=DiffDates("ym",[BIRTHDATE],Now()) my report shows age in Years and months
i.e. 4 years 25 months. I would like display the age in short form like 4Y
25 M. How do I go about this? Kindly help.