This Weeks Birthday(s) Query

So I found this video (http://ift.tt/1FAYYBc) and followed it to do a query for all upcoming birthdays. The video shows how to do it for the next two months and I tried to modify it just for the next 7 days. When I tried to run it, I got "Date type mismatch in criteria expression" error. I tried putting it back in the criteria she had, but still got the same thing.



At 6:53 you can find the code she used for the first table (basically asking when their next birthday is) and at 9:57 is the code for the criteria. Below is my modification.



Between Date() And DateAdd("d",7,Date())



Thanks in advance!

This Weeks Birthday(s) Query