Can we display week1 to week01 ?

[krishna789]

hi,

Can we display week01  instead of week1   .while generating from date.

for example  : week(date) as week

regards,

krishna

[Colin-Albert · Accepted solution]

num(week(date), '00')

[Anonymous]

Hi,

Use the below code to solve your problem.

=Num(Week(Date),'##')

Thanks & Regards,

Venkata Sreekanth