DateDiff(datepart, date1, date2)
you can specify 'D', 'H', 'M', 'N', 'Q', 'S', 'W', 'WW', 'Y', 'YYYY' as the
datepart. Date1 from your table and date2 could be Now() or
CreateODBCDateTime(date).
This will return positive and negatives, depending on the scenario.
Sincerely,
Matthew M. Eschenbaum
Allaire Certified Professional
DevTech Inc.
[EMAIL PROTECTED]
206.956.0888
www.dev-tech.com
-----Original Message-----
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 24, 2001 5:52 AM
To: CF-Talk
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
