d'oh! stupid "long time" format! 1

[javaguy1]

i want time displayed without the AM/PM, like this hh:mm:ss
i guess i can't have that. apparently "short time" does not use AM/PM but medium and long both do.

 

[Transcend]

This is a function i use to convert to date/time format

Public Function CnvDteTime(vardata) As String
If IsDate(vardata) Then
CnvDteTime = "'" & Format(vardata, "dd-mmm-yyyy hh:MM:ss am/pm&quot & "'"
Else
CnvDteTime = "NULL"
End If
End Function

so format(date,"dd-mmm-yyyy hh:MM:ss&quot may give you what you need?

Transcend

 

[javaguy1]

does Format(Time,"hh:mm:ss&quot look legit?
i suppose i could just try it.....

 

[Transcend]

it's MM

if you use little m's it won't work

M= minute
m = month

Format(Time,"hh:MM:ss&quot

Transcend

 

[javaguy1]

ok, i'll give it a try. thanks

 

[javaguy1]

that did it, thanks again transcend. this would all be a lot easier if we had an API like the one Java has instead of this nightmare called MSDN.

 

[zaq888]

can i know the Format(date,"d mmm yyyy&quot

the word format using wat reference? i move to another pc, then error while compiling the code

I'm Keep Studying.... please show the way...
Not Good in English

 

[Transcend]

I'm sorry what are you asking?

You don't need any references to use the Format function.

What are you trying to do?

Transcend

 

[zaq888]

when i compile a progra in another pc, it state error at the word format... can anybody help??


I'm Keep Studying.... please show the way...
Not Good in English

 

[CCLINT]

>if you use little m's it won't work
Then use n's.

zaq888, What is the error number?
And post the line of code with the error.
Check and see if there is a difference in the Country Settings Date format (though if done right, this shouldn't make a difference)

 

[zaq888]

got it...

in order to move / copy foler from one computer to other computer that have the older version, i have to create a new project n add all the form n data report.. got it...
i also cannot detect the exacally problem..

anyaway, Thanks guys

I'm Keep Studying.... please show the way...
Not Good in English