Skip to Content
0
Former Member
Aug 04, 2016 at 01:50 PM

date formula for months issue

23 Views

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.