Access: Format Date "\Www\_yyyy"

user_9410048 0
Viewed 114

I am using Format(Date, "\Www\_yyyy") to have this result.

enter image description here

I would like to keep 2 digits also for the first 9 weeks, for example: W04_2019. But what I get with this formula is:

enter image description here

How to fix this?

ms-access vba
2 Answers

Good question. Seems like you must build it yourself:

Format(DatePart("ww", Date), "\W00") & Format(Date, "\_yyyy")
user_35272970

You can try to use two Format for week number and connect year string with &

Format(Format(Date,"ww"),' \W00')  & Format(Date, "\_yyyy")
user_51760710
Related