I am trying to pull datetime data from an Access db. The field containing
the data is a datetime field called StartDate. I need to calculateI need to
query the db to see if the current date is between tblName.StartDate and
(tblName.StartDate + 7 days).
The SQL should be something like this:
select StartDate, this, that
from tblName
where StartDate between #createODBCdate(Now())# and DateAdd("d", 7,
'tblName.StartDate')
I keep getting errors with various combinations of this that I have tried.
Any ideas how to get this done? I assume that I can use SQL date functions
to make a calculation in the WHERE clause?
Thanks for help.
Paul Sinclair
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
