Week() as '01' for January

[TomBond77]

Hi experts

I have a loop in my script. The result for January is 1. But I need 01 for January, 02 for February and so on.

let vLoadDate = weekname(vLoadDate,1 ,'YYYY/MM'); loop

Any ideas how to fix this?

Thanks, Tom

[Bhuvi · Accepted solution]

Try this,

let vLoadDate = weekname(vLoadDate,1 ,'MM'); loop