Solved
what's the error meaning that I can adjust my query

please help troubleshoot. Thanks a lot!

please help troubleshoot. Thanks a lot!
@chrisyan function InNextDays returns a boolean value and you are comparing it to now() which is a datetime. The error is because of it.
What is the use case you are trying to implement, if you can elaborate maybe the folks on this forum can help you.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.