H HelenLLL Registered User. Local time Today, 17:14 Joined Mar 10, 2014 Messages 18 Mar 18, 2014 #1 I want to design a query: I want a contract START_DATE eg 18.03.2014, the contract LENGTH is 60 months, what date is the end date of the contract. Helen
I want to design a query: I want a contract START_DATE eg 18.03.2014, the contract LENGTH is 60 months, what date is the end date of the contract. Helen
N namliam The Mailman - AWF VIP Local time Today, 18:14 Joined Aug 11, 2003 Messages 11,695 Mar 18, 2014 #2 YourStartDate + 60 Erm that is days, lookup the dateadd function for months
