DateFormat the SQL colum to whatever you need and compare as strings.
That's the easiest way.
Thanks,
Michael Lugassy
Interactive Music Ltd.
I don't live in fantasy; I just work there...
http://www.imvamp.com
[EMAIL PROTECTED]
----- Original Message -----
From: "Joshua Tipton" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, April 24, 2001 2:52 PM
Subject: Date Difference
> cf talk. I want to find out the difference in days between select
> getdate() - expdate which is a date stored in a table. Of course getdate
> pulls the date of the sql server. I need to do this in a select
statement.
> Can anyone help me. I could also do this somewhere else but I need to be
> able to include it in my cfoutput query. If anyone knows the correct
> structure to make this happen in dts please let me know because I can run
it
> in dts and have it update my table.
>
>
>
> Joshua Tipton
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
