Yep, my colleagues who look after the repo system encountered this one last year, as a result of the introduction of 50 year French Bonds. When they were introduced, the Excel add-on that is used for analysis, fell over. This has since been corrected, and the main repo system does not need to project forward 50 years.

The long term step expected to fix this problem, will be the upgrading of our Sybase databases to 64 bit, including migration of the date fields to 64 bits, which is largely complete.

We also were asked to look into the impact on other systems, such as swaps (my area). Swaps run for a maximum of 30 years, but it has been noted that we could have an issue in February 2008 that we need to plan for. This has been deemed "low priority" compared with much other work that is happening, but it's probably worth reminding my business users that we _should_ do a full regression test with the date moved forward to Feb 2008 and beyond, so that we don't get any nasty surprises.