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.
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" & "'"
Else
CnvDteTime = "NULL"
End If
End Function
so format(date,"dd-mmm-yyyy hh:MM:ss" may give you what you need?
>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)
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.