Time Format

[Travis Pupkin]

Hi,

When pulling the hour (or minute, or second, or day, or month, etc) from
the server like:

<%= hour(time) %>

Is there a quick way (like, without an if then statement to check it and
fix it) to format it so it represents all hours in two digits like:

00

for 12 am. instead of just:

0

?

Thanks.

[Kai Boenke]

Hi.

Take a look at function FormatDateTime( ):
http://msdn.microsoft.com/library/de...atdatetime.asp

Travis Pupkin wrote:

<%= hour(time) %>

Is there a quick way (like, without an if then statement to check it and
fix it) to format it so it represents all hours in two digits like:

--
Kai Boenke, QI/LBS-Hi

Robert Bosch GmbH Hildesheim

[Chris Barber]

It's a pity that FormatDateTime won't do what you want, nor will
FormatCurrency etc.

You're probably stuck with creating a small function to return the formatted
string eg.

Function AddExtraZerosIf Req(plngValue)
Dim pstrValue
Dim plngChars
Dim i
pstrValue = CStr(plngValue)
plngChars = Len(pstrValue)
If plngChars < 2 Then
For i = 1 to plngChars Step -1
pstrValue = "0" & pstrValue
Next
End If
AddExtraZerosIf Req = pstrValue
End Function

And referencing it as:

<%= AddExtraZerosIf Req(Hour(time)) %>

NB: This would be easy in Visual Basic, it would be:

Format(time, "00")

Why they missed this obvious functionality from VBScript is beyond me!

Hope this helps,

Chris.

"Kai Boenke" <ka********@de. bosch.com> wrote in message
news:bn******** **@ns2.fe.inter net.bosch.com.. .
Hi.

Take a look at function FormatDateTime( ):
http://msdn.microsoft.com/library/de...atdatetime.asp

Travis Pupkin wrote:

<%= hour(time) %>

Is there a quick way (like, without an if then statement to check it and
fix it) to format it so it represents all hours in two digits like:

--
Kai Boenke, QI/LBS-Hi

Robert Bosch GmbH Hildesheim

[CJM]

Or more simply <%=Right('0' & Hour(Time()),2) %>

HTH

Chris

[Chris Barber]

<in awe>
I didn't see that particular solution but I like it.
</in awe>

Chris.

"CJM" <cj*****@yahoo. co.uk> wrote in message
news:%2******** ********@TK2MSF TNGP11.phx.gbl. ..
Or more simply <%=Right('0' & Hour(Time()),2) %>

HTH

Chris

[Aaron Bertrand - MVP]

http://www.aspfaq.com/2300

"Travis Pupkin" <tp*****@dorrk. com> wrote in message
news:MP******** *************** *@news.individu al.net...

Hi,

When pulling the hour (or minute, or second, or day, or month, etc) from
the server like:

<%= hour(time) %>

Is there a quick way (like, without an if then statement to check it and
fix it) to format it so it represents all hours in two digits like:

00

for 12 am. instead of just:

0

?

Thanks.

[Keith]

Elegant. I plan to use that technique. Thanks.
"CJM" <cj*****@yahoo. co.uk> wrote in message
news:%2******** ********@TK2MSF TNGP11.phx.gbl. ..

Or more simply <%=Right('0' & Hour(Time()),2) %>

HTH

Chris

[Travis Pupkin]

In article <Oz************ **@tk2msftngp13 .phx.gbl>, chris@blue-
canoe.co.uk.NOS PAM says...

<in awe>
I didn't see that particular solution but I like it.
</in awe>

Chris.

Don't be too awed Chris, your suggested worked much better. Although I
would prefer something as simple CJM's code, it didn't account for the
occasional two digits (and would replace the first of the two with a
'0', so at 2 p.m., instead of '14' you'd get '04'.

But your function is as close as I can get to something lean.

Thanks. This group always kicks ass.

[Chris Barber]

Errm,

Wouldn't it just do:

Hour = "14"

Append a zero to give "014" and then take the rightmost two digits to give
"14" again.

Chris.

"Travis Pupkin" <tp*****@dorrk. com> wrote in message
news:MP******** *************** *@news.individu al.net...
In article <Oz************ **@tk2msftngp13 .phx.gbl>, chris@blue-
canoe.co.uk.NOS PAM says...

<in awe>
I didn't see that particular solution but I like it.
</in awe>

Chris.

Don't be too awed Chris, your suggested worked much better. Although I
would prefer something as simple CJM's code, it didn't account for the
occasional two digits (and would replace the first of the two with a
'0', so at 2 p.m., instead of '14' you'd get '04'.

But your function is as close as I can get to something lean.

Thanks. This group always kicks ass.

[Chris Barber]

A possible typo for VBScript [strings]?

<%=Right('0' & Hour(Time()),2) %>

should be:

<%=Right("0" & Hour(Time()),2) %>

Double quotes instead of single-quotes?

Chris.
"Travis Pupkin" <tp*****@dorrk. com> wrote in message
news:MP******** *************** *@news.individu al.net...
In article <Oz************ **@tk2msftngp13 .phx.gbl>, chris@blue-
canoe.co.uk.NOS PAM says...

<in awe>
I didn't see that particular solution but I like it.
</in awe>

Chris.

Don't be too awed Chris, your suggested worked much better. Although I
would prefer something as simple CJM's code, it didn't account for the
occasional two digits (and would replace the first of the two with a
'0', so at 2 p.m., instead of '14' you'd get '04'.

But your function is as close as I can get to something lean.

Thanks. This group always kicks ass.