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

[Chip Harlan]

Why not just do it all in SQL? I think it's usually best to let SQL do
its own time functions...

<cfquery name="getshows" databasse="showstop">
        select * from shows where
        ShowDate BETWEEN getDate() AND dateAdd(ww,1,getDate())
</cfquery>

-----Original Message-----
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 01, 2002 2:18 PM
To: CF-Talk
Subject: RE: How can I add a timespan to a date in sql (access)?


<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



______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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