Week Format

[MikeGeitner]

Hello,

Is there a way to format the week so that on weeks 1-9 there will be a zero preceding the week number? Like "01,02,03..."

I'm using "Format(week,"ww")" currently.

Thanks,

Mike

 

[MikeGeitner]

I think I found it on another post:

Format(Format(Week, "ww"),"00")

I'll try it.................

 

[Remou]

You will need an extra format to change the week number to two digits:

[tt]Format(WeekNo,"00")[/tt]