Jump to content

Need zero before single digit week number - HOW?


stann
 Share

This topic is 6552 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello

I have a situation where there is a date scheme my predecessor used. For example

if it was the date of 12/9/2003 he had assigned a "DATE NUMBER " of 0347 meaning

the year is 03 and the week of that year is 47 . I can figure this out but there is a problem I am having ...

If the week is in the first part of the year ( the single digit weeks) how can I get the zero placed in a calculation? for example

the date is 1/4/2004

I would need the date to calculate to 0401 meaning the 1st week of 2004

but instead I get 041

I could use some help here

Thanks

Stan

Link to comment
Share on other sites

This topic is 6552 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.