Month(Date) and Day(Date) (1 Viewer)

Tieval · Jan 5, 2017

I am defining a document name using the following:

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?

Minty · Jan 5, 2017

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

Tieval · Jan 5, 2017

Perfect and many thanks, I obviously had too much Christmas

stopher · Jan 5, 2017

You could use the following:

Format(Date,"yymmdd")

Minty · Jan 5, 2017

stopher said:
You could use the following:

Format(Date,"yymmdd")

That's too short an answer.

Month(Date) and Day(Date) (1 Viewer)

Tieval

Still Clueless

Minty

AWF VIP

Tieval

Still Clueless

stopher

AWF VIP

Minty

AWF VIP

Similar threads

Users who are viewing this thread