Changing a Julian date back to a calendar date

I need to change a julian date back to a calendar date, can anyone help?

Julian date 10,004 back to 01/04/10.

Thanks

 

 

By: Ed Gordley posted: 14th January 2010 - 19:06


Replies

Michael M. Dorn at 17th January 2010 - 18:32 says:

Hi Ed,

use this formula to convert back to calendar date: (date(01,01,firstc(julianDateField,2)) + lastc(julianDateField,3)) - 1

Mike


Ed Gordley at 18th January 2010 - 18:16 says:

Thanks Mike I'll give it a try!!


Please login to leave your own comments