Another Conditional Formatting Question

[JamesJ]

I'm trying to set conditional formatting with an expression where the date
is between today and 6 days in advance. I've tried the following with no
success:
[ReminderDate] Between Date() And Date()+6

Any help will be appreciated

Thanks,
James