Solved

How to pull a two digit Fiscal Week from the system date.

Posted on 2013-02-05
2
399 Views
Last Modified: 2013-02-12
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:

DatePart("ww",Date())

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?
0
Comment
Question by:zepold
2 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
Comment Utility
Try this:

Format(DatePart("ww",Date()),"00")

Open in new window

0
 

Author Closing Comment

by:zepold
Comment Utility
That did it! Thank you very much.

dl
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
This collection of functions covers all the normal rounding methods of just about any numeric value.
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now