Rivercity Technology Services LTD Logo
HomeAbout Us
Technology Services
Icon showing a support technician
IT Support Services
Cybersecurity Risk Management at one predictable flat rate.
Icon showing a hand holding a phone
Business Phone Services
VoIP Telephone solutions from RCT. 
Icon showing a database and a cloud
Backups & Recovery
Cloud & On Premise - ready to recover!
Icon showing computer code on a monitor
Software Development
Web & Mobile App development
Icon showing website wireframes
Website Development & Hosting
Web design and full hosting & maintenance packages!
Icon showing an envelope being opened
Modern Email Management
Microsoft 365 email provisioning, security & management.
“You’re giving me the ‘it’s not you, it’s me’ routine? I invented ‘it’s not you, it’s me.’ Nobody tells me it’s them not me; if it’s anybody, it’s me.”
- George Costanza
Learning CenterContact Us
Book A Consultation
Illustration of a person writing a blog post with a pencil

How old is that person?

Another simple but powerful piece of code I get asked for a lot:  Age calculations.  it sounds so simple...but it isn't!  You can use variations of this for other purposes like aging receivables, calculating time lapse, etc.

Requirement:  a date field (in this case I have their birthday in [DOB] which is a date field storing mm/dd/yyyy).

Add an unbound field on the form or report, set it's value to this:

No more work figuring out age!

The why not go the extra mile, and add code to alert the user a birthday is coming up.  You need to grab ONLY the Month and Day, NOT the year.  Then test to see if that is within a week either way of today's date.  if it is, use conditional formatting, or pop up a message, or alert the user...never miss a client birthday wish if they are at your office when you pull them up in the system!

Jeff Shirley
Article Written by Jeff Shirley
Related Articles
2022 - Copyright, All Rights Reserved