I wish to run a query that adds 60 days to a date. ie [Date] +60 Days ideas please TIA Steve
S Steve Schanzer Mar 14, 2009 #1 I wish to run a query that adds 60 days to a date. ie [Date] +60 Days ideas please TIA Steve
M Marshall Barton Mar 14, 2009 #2 Steve said: I wish to run a query that adds 60 days to a date. ie [Date] +60 Days Click to expand... Actually, [a date field]+ 60 will work, but it relies on the knowledge of how a date field is encoded. Better to use the DateAdd function: DateAdd("d", 60, [a date field])
Steve said: I wish to run a query that adds 60 days to a date. ie [Date] +60 Days Click to expand... Actually, [a date field]+ 60 will work, but it relies on the knowledge of how a date field is encoded. Better to use the DateAdd function: DateAdd("d", 60, [a date field])
