I have a requirement to be able to display Financial Year/Weeks/Periods for a number of dates in different objects. In our old Sql system we had a calendar table that was simply a long list of dates along with the FY/Period/Week data and i could just join any date to it as and when. My current thinking is store the same calendar table in custom settings and then create wrapper classes to display the data in VF, however im struggling with this...
As an example i need to display a pageBlockTable showing certain info from the Site object plus the Fiancial Year/Week and Period that the record was added.
So, is the above approach sensible, if so any idea how i should go about it? if not any suggestions of the best way of achieving the desired results?
Thanks for any suggestions. Paul