B Barclay Berger Nov 3, 2003 #1 How do I build a query that will take a date plus 10 years? I've tried Exp: [recdate] + 3650? Thanks Barclay
How do I build a query that will take a date plus 10 years? I've tried Exp: [recdate] + 3650? Thanks Barclay
C Cheryl Fischer Nov 3, 2003 #2 There is a function named DateAdd() that will do that for you. If you want to use it as a calculated field in a query, put the following in the top row of a column in Query Design: NewDate: DateAdd("yyyy", 10, [MyDate]) hth,
There is a function named DateAdd() that will do that for you. If you want to use it as a calculated field in a query, put the following in the top row of a column in Query Design: NewDate: DateAdd("yyyy", 10, [MyDate]) hth,
