> From: [EMAIL PROTECTED] > Date: Wed, August 02, 2006 8:40 am > To: [email protected] > > Does anyone have experience, tips or pitfalls with handling a company's > switch from a calendar year (Jan - Dec) to a fiscal year (Jul - Jun) in a > VFP app? The switch is the result of an acquisition. We were acquired by > a larger company and they're imposing their calendar on our systems. > > I'm wrestling with reporting right now. Management wants reports for the > pre-acquisition period to be the old calendar and 2006 and later to be the > new calendar. We came up with a stub year to help with this. Meaning > 2004 and earlier will be Jan - Dec, 2005 (the stub) will be Jan - Jun and > 2006 and beyond will be Jul - Jun.
I'd change your date picker for reporting proposes to present either period type, and add that to the page footer for the reports for a while. > One issue I have is some reports cover multiple years. They have years > down the left side and 12 mos. across the top. I can break on year and > change the report headings in the printed version based on the year OK I > think. But if they send the report to an Excel file, how can I name the > columns for different years? They want the columns for the fiscal year to > be Jul-Jun and calendar year Jan - Dec in the same file. Do I stop using > the actual month names and use something like "period 1", "period 2" etc. > and put the burden on the user to figure out which month period 2 is? That is a tough call. I had to do rolling reports for some stupid reason. I took the date and parsed it this way. YYYY MM and you need the 0 in the month for Jan to Sept. I used that in my cross tab reports and it worked fine as the X axis. HTH _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
