If yes, the the dates returned in the query are correct.
Sometimes, having an _expression_ like -totalDateDiff causes problem with lousy typed ColdFusion.
I would suggest you invert the two parameters in dateDiff and forget about the minus sign:
<!--- Date diff in minutes --->
<cfset totalDateDiff = datediff("n",TimeOnHoldReleased,TimeCallPlacedOnHold)>
DateAdd("n",totalDateDiff,queryTmp.FixDateTime)
If the dates are in text format in the database, then you must create date objects in CF
with createDateTime() before you submit them to dateDiff() etc.
--
_______________________________________
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
