Julian Date Conversion 1

[Zoee]

Using Crystal Reports Version 8 off JD Edwards World (AS400)and need help converting a Julian date stored as CYDDD.

Thanks

 

[dgillz]

There is a juliantodate() function which can be downloaded at the cryatal decisions website. Here is the link. Lots of other cool UFLs there as well.

http://support.crystaldecisions.com/communityCS/FilesAndUpdates/ufljul.exe.asp

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

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[rhinok]

CYDDD isn't really 'true' julian date formatting. As a result, you might not be successful using the custom ufl. Follow this link to a knowledge base article that is specific to J.D. Edwards One World date conversion.

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

Good Luck!