I have to look at children's date of birth to determine 3 groups, 6 - 12- and 18 months.
As I see it, I have to compare the current date against their Date of birth and place assign them. the under 6 months would be called '6 months'
the 7-12 is '12 months' and 13-18 is '18 months'. We have special medical services to offer these ages.
Is there such a way to subtract dates to determine the month of child? Note the record select I am limiting to age 2 and under. The table does have age but not as a months,only 1 and 2 would be in our record select.
The field type is datetime.