Symptom
- Not able to see the DateToJulian() function or JulianToDate() function while writing the formula in Formula Workshop - Formula Editor.
Reproducing the Issue
Product: Crystal Reports 2008.
Operating System: Microsoft Windows XP SP1.
Resolution
- Julian dates (abbreviated JD) are simply a continuous count of days and fractions since noon Universal Time on January 1, 4713 BCE (on the Julian calendar).
- To resolve this issue you have to use the Julian Date UFL called ufljul.exe, which can be download from the link below.
http://support.businessobjects.com/communityCS/FilesAndUpdates/ufljul.exe.asp - After the ufljul.exe is downloaded, unzip the exe and then copy the 2 dll (U2LJUL.DLL and UFLJUL.DLL) into the path C:\Programs Files\Business Objects\ Business Objects Enterprise 12.0\win32_x86.
- Open the Crystal Reports application and go to the Formula Workshop - Formula Editor and you will be able to use the JulianToDate() function as well as DateToJulian() function.
- Formula Syntax :
DateToJulian (date) - Takes a date field and returns the Julian date values.
JulianToDate (number) - Takes a Julian date and returns the date value.Examples:
DateToJulian (date(2007,11,27)) would convert 11/27/2007 to Julian.
JulianToDate ({table.datefield}) would convert the Julian date to a Date field.
Keywords
Julian Date
Product
Crystal Reports 2008 V0