SAP Knowledge Base Article - Public

1688156 - UFL 'u2ltdate.dll' that implements this function is missing in Crystal Reports

Symptom

  • Error when refreshing some reports.
  • Was able to refresh the report before in Crystal Reports.
  • After migrating from an older product version, like Crystal Reports 8.5, to a newer version, the report fails to refresh and displays the error:
        
    "UFL 'u2ltdate.dll' that implements this function is missing in Crystal Reports"

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

Reproducing the Issue

  1. In Crystal Reports, open a report.
  2. When refreshing the report, it fails with the error: 
      
    "UFL 'u2ltdate.dll' that implements this function is missing in Crystal Reports"

Cause

  • This error occurs if the report contains a formula that uses the function: NumberToDate
  • This function is not part of Crystal Reports standard functions.
  • It is an additional function added by a User Function Library (UFL) created by Seagate Software.
  • The UFL that implement this additional function, U2ltdate.dll, is not install on the computer, and this is why the report fails to refresh.

Resolution

  • To be able to refresh the report successfully, perform one of the following:
       
    • On the computer where the report was refreshing successfully, locate the file: u2ltdate.dll,
      and copy it to the following directory on the computer where the report is failing to refresh:
           
               C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86
          
      Then close, and re-open Crystal Reports.
                      
      OR
             
    • Download the file: U2LTDATE.ZIP, from the attachments section, then copy the file: u2ltdate.dll, to the following directory:
        
               C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86
       
      Finally, close, and re-open Crystal Reports.
        
      OR  
         
    • Modify the formula that uses the function: NumberToDate, and replace the function by code that converts a number to a date.
      Since the function NumberToDate converts a Numeric value in the format YYMMDD to a date, then the updated formula will be like:
            
      Local NumberVar myNumericDate := <INSERT YOUR NUMERIC DATE FIELD HERE>;
      Local StringVar myTempDate := ToText(myNumericDate,0,"");
      If Length(myTempDate) = 6 Then
      (
      Local NumberVar myYear := ToNumber(myTempDate[1 to 2]);
      myYear := If myYear < 50 then myYear + 2000 else myYear + 1900;
      Local NumberVar myMonth := ToNumber(myTempDate[3 to 4]);
      myMonth := If myMonth in 1 to 12 Then myMonth Else 0;
      Local NumberVar myDay := ToNumber(myTempDate[5 to 6]);
      myDay := If myDay in 1 to 31 Then myDay Else 0;
      Date(MyYear,MyMonth,MyDay)
      )
      Else Date(0,0,0)
         
    • Note: The above formula is only provided as an example, on how to convert a numeric date in the format YYMMDD to a date.

See Also

CR, Seagate Softare UFL

Keywords

UFL 'u2ltdate.dll' that implements this function is missing, u2ltdate.dll,crystal reports. , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016

Attachments

U2LTDATE.zip