I am trying to create a select query in Access2000, that uses the birthdate as the main selection criteria.... I want to select only the dd/mm part of the date, and ignore the yyyy part. The date format has been set to dd/mm/yyyy.
I know the command is something like -
between date part(dd,mm)+14 and date part(dd,mm)+28
but I am not sure of the exact syntax, and cannot find reference to it anywhere! (As you can see, I am trying to get the query to warn me of upcoming birthdays).
Any help would be greatly appreciated,
Thanks everyone,
Shaun.
