karatelung
Registered User.
- Local time
- Today, 10:59
- Joined
- Apr 5, 2001
- Messages
- 84
I currently use this as my Control Source for an unbound text box to show the no. of years a client has been licensed:
=DateDiff("yyyy",[LicenseDate],Now())+Int(Format(Now(),"mmdd")<Format([licensedate],"mmdd"))
When a client has been licensed for less than 1 year, it shows "0". How can I get my text box to show years and months?
Thanks
=DateDiff("yyyy",[LicenseDate],Now())+Int(Format(Now(),"mmdd")<Format([licensedate],"mmdd"))
When a client has been licensed for less than 1 year, it shows "0". How can I get my text box to show years and months?
Thanks