Padding a Date String

Some functions return dates in single units (1st May 1996 maybe returned as 5-1-96). This makes formatting difficult whereyou 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 IfEnd Function
Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: