Re: SQL: How can I add a timespan to a date in sql (access)?

2002-04-02 Thread ksuh
L PROTECTED]> Date: Monday, April 1, 2002 12:11 pm Subject: SQL: How can I add a timespan to a date in sql (access)? > Hi - I want to add a week to a date in sql(access) and then compare > against that date. > > > select * from shows where > #createodbcd

SQL: How can I add a timespan to a date in sql (access)?

2002-04-01 Thread Matthew R. Small
Hi - I want to add a week to a date in sql(access) and then compare against that date. select * from shows where #createodbcdate(now())# between todate and <<>> Thanks, Matt Small __ Your a