I think this is possible, I just don't know how to do it...

Our fiscal year begins on 01/29/2011 and ends on 02/03/2012 and I need to return the current fiscal week (which as of 6/22/2011 is week 21). Is there a way to accomplish this so that it is dynamic based on today's date?

Any help you can provide me is appreciated in advance!

Thanks,

This message has been edited. Last edited by: kadkins,

Here are a couple of posts that I hope inspire you:

[SOLVED] Elegant way to define fiscal years?

[CODE] Simplifying the use of Date functions in Dialogue Manager

Cheers,

Thanks Francis. I actually figured out how to do exactly what I needed and was coming here to close this thread.

Thanks for the quick response!

I ended up creating a custom field that returns the number of days between the FY begin date and today and divides that number by 7.

Thanks again!