K kitty77 Registered User. Local time Today, 01:33 Joined May 27, 2019 Messages 715 May 17, 2021 #1 I'm trying to make a query that would return results that are 60 days before a due date. The field is [Duedate] Not sure of the syntax. Does it need to be a range in order to return the proper results?
I'm trying to make a query that would return results that are 60 days before a due date. The field is [Duedate] Not sure of the syntax. Does it need to be a range in order to return the proper results?
arnelgp ..forever waiting... waiting for jellybean! Local time Today, 13:33 Joined May 7, 2009 Messages 20,222 May 17, 2021 #2 ... Where ((Date() - 60) >= [Duedate]) oR ... Where (([DueDate] - 60) <=Date()) whichever will work for you. Last edited: May 17, 2021
... Where ((Date() - 60) >= [Duedate]) oR ... Where (([DueDate] - 60) <=Date()) whichever will work for you.
