?
Solved

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

Posted on 2013-02-05
2
Medium Priority
?
433 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 2000 total points
ID: 38857315
Try this:

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

Open in new window

0
 

Author Closing Comment

by:zepold
ID: 38880347
That did it! Thank you very much.

dl
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
An introductory discussion about Oracle Analytic Functions which are used to calculate or compute Aggregate values, based on a group of rows.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

589 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