Time Format

[mr moe]

I have this code for an excel file in vba, strDate = Format(Date, "mm-dd-yy") & " " & " at " & Format(Time, "h-mm-ss").

I'm trying to put colons ":" instead of the dashs "-" for the time but I get a debug error, is there any way I can make it work, or am i stuck with dashes. Thanks.

 

[RuralGuy]

What debug error do you get when you try Format(Time,"h:mm:ss")? It works just fine on my system.

 

[mr moe]

time format

thanks, i'm doing this in excel and i'm getting this error msg. See attachment. Thanks.

 

[RuralGuy]

Well I don't see an attachment and you may have better luck in the Excel forum. http://www.access-programmers.co.uk/forums/forumdisplay.php?f=55

 

[wazz]

try a back-slash before the colons. (??)