Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Visual Basic
Expertise: Beginner
Aug 6, 1997

Padding a Date String

Some functions return dates in single units (1st May 1996 may be returned as 5-1-96). This makes formatting difficult where you have dates like 5-1-96 and 12-15-96 on the same column.

The function below returns a string preceded by "0" if the length of the string is less than two. If "5" is passed to the function, it returns a "05." Passing "15" to the function returns "15":

 
Function cto2d (u As String) As String

        If Len(u) < 2 Then
                cto2d = "0" & u
        Else
                cto2d = u
        End If

End Function



Segun Oyebanji
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date