I'm not sure exactly where your variables are coming from:
If StartDate and StartVisit are both in the table, why not use
where StartDate > StartVisit.
If one is in a different format, then use a SQL function to convert it
where StartDate > to_date('#StartVisit#','DD-Mon-YYYY')
Brian
-----Original Message-----
From: Paige Chandler [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 20, 2001 11:06 PM
To: CF-Talk
Subject: Selecting on dates
Hi All,
The following function works great for displaying a date, but StartVisit
isn't found when trying to compare it in a Select statement. I'd really
appreciate an example of the correct syntax to use. TIA.
Regards,
Paige
Select *
>From WebSite
WHERE StartDate GT #DateFormat(StartVisit,'mm-dd-yy')#
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists