I am trying to salvage some statistics (we are changing database) in the old database an ordinary date isn’t used instead 2006002 is used for the date 2006-01-02. 2006003 for 2006-01-03. This is some kind of "special" format year and day of that year. I have data from 1997-01-01 until today. 2006-04-07 is 2006097.
The problem in short: Make 2006002 to 2006-01-02. 2006097 to 2006-04-07.
The only solution I have is to make some lookup table from 1997 until today.
But maybe some formula genius has some better solution?
Any help will be greatly appreciated TIA /Mats