formatinng time and sending as parameter to sql thic code does that
CODE:
Private Function FomatTime(ByVal strhours As String, ByVal strminutes As String, ByVal strseconds As String, ByVal strampm As String) As String 
Dim formattedstr = "" 
If (strhours.Length < 2) Then 
strhours = "0" & strhours 
End If 
If (strminutes.Length < 2) Then 
strminutes = "0" & strminutes 
End If 
If (strseconds.Length < 2) Then 
strseconds = "0" & strseconds 
End If 
formattedstr = " " & strhours & ":" & strminutes & ":" & strseconds & " " & strampm 
Return formattedstr 
End Function


0 comments:
Post a Comment