Select DateDiff(d, GETDATE(), expdate) from ... where...
-----Original Message-----
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 24, 2001 1:52 PM
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
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
