D
dimatisah
I have an Access database of client information with their birthdate stored
in a field called Birthday, in m/d/yyyy format.
I need a query that will let me find everyone with a birthdate during a
certain date range no matter what year they were born. For example, if I
wanted everyone born during this week, from 3/22-3/28 of any year.
Is there a way to either: A) Change my date fields in the table to only m/d
somehow? or B) Query the month and day only, ignoring the year?
I'd prefer Option B, but am open to anything that might make it work.
Thank you!
in a field called Birthday, in m/d/yyyy format.
I need a query that will let me find everyone with a birthdate during a
certain date range no matter what year they were born. For example, if I
wanted everyone born during this week, from 3/22-3/28 of any year.
Is there a way to either: A) Change my date fields in the table to only m/d
somehow? or B) Query the month and day only, ignoring the year?
I'd prefer Option B, but am open to anything that might make it work.
Thank you!