Hi. I was wondering if I could get some assistance with the question below.
Find all the male employees born between 1962 to 1970 and with hire date greater than 2001
and female employees born between 1972 and 1975 and hire date between 2001 and 2002.
I have attempted the question with the query below but it only provides me with information on the Male employees and when I try using AND instead of OR I get blank results. Thank you
[Gender] = 'M' AND
year([BirthDate]) BETWEEN 1962 AND 1970 AND
year([HireDate]) > 2001
[Gender] = 'F' AND
year([BirthDate]) BETWEEN 1972 AND 1975 AND
year([HireDate]) IN (2001, 2002)