I am defining a document name using the following:
Last month this returned, for example, COC161225 on Christmas Day but today it returns COC1715 and I am trying to return COC170105.
Is there a way to get it to return the month and day as two figures always?
Code:
CoCName = "COC" & Right(Year(Date), 2) & Month(Date) & Day(Date)
Last month this returned, for example, COC161225 on Christmas Day but today it returns COC1715 and I am trying to return COC170105.
Is there a way to get it to return the month and day as two figures always?