a couple of quick points:
1) what you see is a string representation of a date or time. If
it's a true dateTime object, the underlying value is a decimal
(starting from the Epoch time? can't remember)
2) if you're after a formatting function in CF to convert this decimal
to a string that
Hi Barry,
Thanks for the suggestions. I've just come up with a quick hack which will
do what I need, so I guess I'll just go down this track:
cfset stringVal = 0.00208101851852
cfset multiplicationFactor = 24 * 60 * 60 !--- hours x minutes x seconds
---
cfset timeInSeconds = stringVal *
Hi Andrew,
this is already worked out but here is an alternative CF answer which
makes me ask was '2 mins 50 secs' an actual time? because:
cfset addTime = 0.00208101851852 /
cfset thisTime = CreateTime(0,0,0)+addTime /
cfoutput
thisTime: #thisTime#br
formatted: #TimeFormat(thisTime,
Hi Kym,
That's great - thank you!
The 2 mins 50 I quoted in there was just a made uppie - I think the actual
value for that one was 2:59 and 8 tenths so it looks spot on.
Thanks for the solution - I will keep it on file as I have doubt it will be
something I revisit again.
Regards,
Andrew.