Hello everyone,
So what I am trying to do is pull a query where all results come based on a referral date. I only want to see referrals that do not have a DOS that were generated 60 days from today going back. So the referral date would have to be 60 days in the past from the current date. The effective date that this policy starts is 02/06/2017 so that is where that date comes from.
This is what I have but it is not pulling the right information and I can't figure out why:
<Date()-60 And >#2/6/2017#
Thank you all!