View Full Version : DOB Criteria


mynanforever
06-09-2008, 11:08 AM
I need the criteria for the following:
I need to see a list of patient's ages 6months to 5 years, however there is no age field there is only a date of birth field.

pbaldy
06-09-2008, 11:21 AM
Welcome to the site. Try a criteria of this on the DOB field:

Between DateAdd("yyyy", -5, Date()) And DateAdd("m", -6, Date())