1804866 - How to convert Current date to Julian date in Crystal Reports?

SAP Knowledge Base Article - Public

1804866 - How to convert Current date to Julian date in Crystal Reports?

Symptom

How to convert Current date to Julian date format?

Environment

  • Crystal Reports 2008
  • SAP Crystal Reports 2011

Resolution

  1. Create a formula that will calculate the Julian Date as:
                     numberVar k:=year(CurrentDateTime);
                     numberVar m:=month(CurrentDateTime);
                     numberVar l:=day(CurrentDateTime);
                     numberVar JD;
                     JD:=(-32075+1461*(k+4800+(m-14)/12)/4+367*(m-2-(m-14)/12*12)/12-3*((k+4900+(m-14)/12)/100)/4;
  2. Save and close the formula editor.

See Also

http://scn.sap.com/thread/3262580

Keywords

Current Date to Julian date, Julian Date format , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011