Some of this was just for show:
<cfset old_date = "#CreateDateTime(2003, 02, 25, 08, 00, 00)#">
<CFOUTPUT>
Current Date: #DateFormat(Now(),"MM/DD/YYYY")#
#Timeformat(Now(),"HH:MM:SS TT")#<br>
Original Date: #DateFormat(old_date,"MM/DD/YYYY")#
#Timeformat(old_date,"HH:MM:SS TT")#<br>
<cfset new_minutes = #DateDiff('n',old_date,Now())# -
(DateDiff('h',old_date,Now())*60)>
Time Difference is : #DateDiff('h',old_date,Now())# hours and
#new_minutes#
</CFOUTPUT>
>>> [EMAIL PROTECTED] 02/26/03 10:25AM >>>
Hey guys and gals!
I have two fields..date1 and date2.
I use DateDiff to get the hours between them..but I need to go deeper
to
hours and minutes.
So I'm thinking I use datediff to get the Minutes...
And then what?
Use Minutes/60 to get hours and then MOD(Minutes) to get the Minutes
extra??
*sigh*
I've never checked out math functions in CF....would that work?
-Gel
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=5
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
