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. 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? -- Andrew --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ 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.
