Converting Julian date to Normal Date (1 Viewer)

[wan2fly99]

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

 

[namliam]

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...