S Scottie31 Registered User. Local time Today, 14:07 Joined Jan 11, 2006 Messages 30 Feb 22, 2006 #1 How do I run a query so that I do not have to keep changing the date. I want to run a query everyday but want to use the date from the day before. I want to use yesterdays date for today and then todays date tomorrow. Thanks.
How do I run a query so that I do not have to keep changing the date. I want to run a query everyday but want to use the date from the day before. I want to use yesterdays date for today and then todays date tomorrow. Thanks.
L llkhoutx Registered User. Local time Today, 12:07 Joined Feb 26, 2001 Messages 4,013 Feb 22, 2006 #2 Yesterday is Date()-1. Dat() is todays date, assuming your PC's clock is working.
S Scottie31 Registered User. Local time Today, 14:07 Joined Jan 11, 2006 Messages 30 Feb 22, 2006 #3 Perfect.....thanks
