> I need to get the 1:36 now.
>
> UGH!
You should be able to do DateAdd to do this - create a date for your 12
minutes:
periodlength = CreateDateTime(2000,1,1,0,12,0)
Then, figure out the number of seconds in your submitted time:
secs = minute(mytime) * 60 + second(mytime)
and then subtract secs from the 12:00 time using a negative value for
DateAdd:
DateAdd("s",-secs,periodlength)
Something like that anyway...
-- Josh
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7.
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282729
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
