finding range of months

[nati]

hi all,

before i dive into this i figure somebody must have done this before. i want to find birthdays for any date within usually a month period. so say everybody that has a birthday in june, but the 6/1/1925...6/30/2001 doenst' work. how can i find just the months for any year?

all help appreciated!

nati

[Steven H. Blackwell]

Take a look at the Month(date) function under the DateFunctions. If you have a field "birthday" then define a second field called "BithMonth".

BirthMonth=Month(birthday)

returns 1 to 12.

Search on that field. Or you can use MonthName in a similar fashion. Returns Jan...Dec

HTH

Old Advance Man

[Steven H. Blackwell]

>but the 6/1/1925...6/30/2001 doenst' work.

I should have added that this finds everyone born BETWEEN these 2 dates, irrespective of the month or year.

Old Advance Man

[nati]

thanks! ya learn sump'in new everyday!