handlewithcare
Programmer
I have an application that, due to Y2K and other issues, stores dates in an unusual format. To read this data as number of days since 01/01/1900, negative values must be added by 52755 and positive values must be subtracted by 12785. I am trying to create a VIEW the will enable this to look normal. I have created a formular in ACCESS which translates the values, but I'm unsure how to write this in SQL.<br><br>IF datefield<0 THEN datefield+52755 ELSE old_date-12785<br><br>If anyone has any ideas/solutions they would be gratefully recieved.<br><br>Many thanks in advance