Month(Date) and Day(Date)

[Tieval]

I am defining a document name using the following:

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?

 

[Minty]

Try using
Format(Datepart("m",Date()),"00")
and similar for the Day part

 

[Tieval]

Perfect and many thanks, I obviously had too much Christmas

 

[stopher]

You could use the following:

Format(Date,"yymmdd")

 

[Minty]

You could use the following:

Format(Date,"yymmdd")

That's too short an answer.