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

Mon, 01 Apr 2002 11:00:10 -0800 

<cfset  thisWeek = #Now()#>
<cfset nextWeek = #DateAdd('ww',1,thisWeek)#>

<cfquery name="getshows" databasse="showstop">
        select * from shows where
        ShowDate between
        #createODBCDate(thisWeek)# and
        #createODBCDate(nextWeek)#
</cfquery>

-----Original Message-----
From: Matthew R. Small [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 01, 2002 1:12 PM
To: CF-Talk
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.

<cfquery name="getshows" databasse="showstop">
        select * from shows where
        #createodbcdate(now())# between
        todate and
        <<<a week from todate>>>
</cfquery>


Thanks,
Matt Small


______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to