Converting Military Times 1

[jl8789]

Is there any way to convert this into a time value in Cold Fusion?
1348 into 1:48?

Thanks

 

[webmigit]

#timeformat(militarytime,"hh:mm ss")#

And to convert vise versa

#timeformat(regtime,"HH:mm ss")#

notice the case of HH or hh in both.

http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/functions-pt2105.htm#1113706

ALFII.com

http://www.alfii.com

---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.

 

[jl8789]

This isn't working?
<cfoutput>#timeformat(1348,"HH:mm")#</cfoutput>
nor is
<cfoutput>#timeformat(1348,"hh:mm")#</cfoutput>

 

[webmigit]

1348 is not a time...

Let's convert it into a time... or try to

<Cfset datenum=1348>
<Cfoutput>#timeformat(CreateDateTime(year(now()), month(now()), day(now()), left(datenum,2), right(datenum,2), 0),"hh:mm ss tt")#</cfoutput>

ALFII.com

http://www.alfii.com

---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.

 

[jl8789]

Thanks for the help.

This works.

 

[webmigit]

Was in a hurry earlier..

That won't work quite right on 3 digit numbers (948).. Here's the solution...

You'll see the mods in bold.

<Cfset datenum=1348>
[b]<cfset datenum=numberformat(datenum,"0000")>[/b]

<Cfoutput>
  #timeformat(CreateDateTime(year(now()), month(now()), day(now()), left(datenum,2), right(datenum,2), 0),"hh:mm ss tt")#
</cfoutput>

or

<Cfset datenum=1348>

<Cfoutput>
  #timeformat(CreateDateTime(year(now()), month(now()), day(now()), left(datenum,[b]len(datenum)-2[/b]), right(datenum,2), 0),"hh:mm ss tt")#
</cfoutput>

ALFII.com

http://www.alfii.com

---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.