I have a database where I query records up to the prior fiscal week. The data contains a two-digit fiscal week, (ex: 01 - 52). When I get the fiscal week from the system date, it comes back as a 1 digit week. At least, until I get to fiscal week 10. The formula that I am using is:
I need to find a way to embed a zero for weeks 1 - 9 and not for the weeks 10 - 52. In the formula above, even though I use "ww", I will only get one digit for the fiscal week.
Is there a way to do this?