SAP Knowledge Base Article - Public

1263435 - Reports do not display Julian Date in Crystal Reports 2008 SP0 (Version 12.0.0.683)

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

  1. 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).
  2. 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  
  3. 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.
  4. 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.
  5. 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.
  6. 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 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

Crystal Reports 2008 V0