In my database (Btrieve) there is a field stored as a Julian Date, actually stored as a number which represents a Julian Date

I am trying to do a DATEDIFF function with this date and it says
I need a date


How do I change that Julian Date to a normal Dtae field


Any help is appreciated

Julian accoording to Wiki is the number of days passed since January 1, 4713 BC

So you "simply" have to convert this to an access (or M$) date. This is based of Januari 1, 1900 AD

So simply take the julian number, find out the julian date for Januari 1st 1900 and substract that. Convert the double to a date and .... done...