Date Formula

[crystalwriter]

I have a "like" Julian Date of 103015 that stands for:

1 - the 21st century
03 - 03 year in 21st century (2003)
015 for January 15th (the fifteenth day into the year 2003).

How do I convert this to 01/15/2003

 

[dgillz]

Are you sure its not 10315?

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[crystalwriter]

It is like a Julian Formula - but not a Julian - that is why I am having problems. It is a date coming from JDEdwards - 103015.00 - I need to change it to 01/15/2003

 

[synapsevampire]

Here's the whitepaper:

http://support.crystaldecisions.com/library/kbase/articles/c2012088.asp

-k