TWO DIGIT WEEK #

[akuttler]

I have a custom dimension for Year Week# as follows:

= Year(Date) & ' ' & (Week([Date])

How would I make the week # always appear as two digits for example

2018 01

2018 02

etc.

Thanks.

[yujiyamane · Accepted solution]

It should be as below.

= Year(Date) & ' ' & num( Week([Date]), '00')