In Access Expert 28, Lesson 7 around the 9 minute mark, after calculating the date difference between next birthday and the current date, you can use this to calculate birthdays coming up within the next 60 days using the criteria <60. As stated you need to use a seperate query, taking the DD part then using the criteria as the current query can't perform the necessary calculations, then apply the criteria.
So I created the new query and ran it no problems until I applied the <60 criteria where I got a "Data type mismatch in criteria expression" error. Any Ideas how to sort this ?

---

Reply from Alex Hedley:

Can you try just 60 and see if it's the same.
Might be getting mistaken with the data type.
Had you changed the properties for true/false and it carried over?
I'll do some digging too