Quote Originally Posted by Danno2cu View Post
To be more descriptive, my example should have been something more like: How do I locate all instances of Calendar Date Monday March 5, 2012 and convert it to Fiscal Date Monday June 4, 2012 and then Tuesday March 6, 2012 and convert it to Tuesday June 5, 2012?

Does this help clarify?
That clears up one misunderstanding I had, but unfortunately raises another. Why is the March dates being advanced to June? My first impression is that all dates would be advance by six months. Then, in re-reading your original message coupled with your last message, I could not decide if the "add 6 months" was a blanket rule for any date or if you wanted all dates advanced to July of that year, but moving from March to June does not fit in with either of those "guesses" by me. Maybe you could post a table with one or two dates from each month of the year and show me the dates they should become... then maybe I will be able to see the underlying logic for your request, but right now, I seem to be completely missing it.