Re: Jd Edwards Julian Date Conversion
Quote from turtle44
Julian dates are normally 5 digits; what is the 6th digit used by Jd Edwards?
Not in my experience, all of the Julian dates I have come into contact with have been 6-7 digits long. The 6th digit in Julian Date represents the century value.[hr]*[/hr] Auto Merged Post;[dl]*[/dl]
Quote from daddylonglegsDisplay More
With a formula you can just use:
for VBA perhaps see solution(s) suggested here - I haven't tried them.....
or perhaps a simpler formula that would also cater for A1 being a formatted number rather than text, i.e. leading zeroes might not exist....
Both of your formulas work like a charm for the JD Edwards Julian Date: 105210 = 7/29/2005. Thank you for your help, this is much easier than the way I was trying to do the conversion!