SAP Knowledge Base Article - Public

1217652 - What is the difference between CurrentDate, DataDate and PrintDate?

Symptom

In Crystal Reports (CR), several functions and Special Fields can display different dates depending on the report design requirements.

What is the difference between CurrentDate, DataDate and PrintDate?

Environment

  • Crystal Reports XI Release 2
  • Crystal Reports 2008

Resolution

PrintDate:

PrintDate is a CR function that displays the last date that the report was printed. This value can be set from the Report menu by clicking 'Set Print Date and Time'.

====================

NOTE:

Print Date is a special field available in the Field Explorer.

PrintDate is a CR function. Either choice displays the last date that the report was printed.

====================

CurrentDate:

CurrentDate is a CR function that displays the current date according to Windows Regional Settings in Control Panel. This value can be set from the Report menu by clicking 'Set Print Date and Time'.

It is commonly used to output the current date or to filter data based on a date range. In a record selection formula, use CurrentDate to filter data between an earlier date and the current date.

{date field} in {start date field} to CurrentDate

====================

NOTE:

When publishing to Crystal Enterprise, unintended results may occur when CurrentDate is used in record selection. As a workaround, substitute CurrentDate with DataDate. For more information, search for article c2010138 at:

http://support.businessobjects.com/search/

====================

DataDate:

DataDate is a CR function that displays the last date that the report was refreshed. For example, if a report is opened on January 25, 2004 but was last refreshed on January 1, 2000 then the DataDate function will output January 1, 2000.

====================

NOTE:

Data Date is a special field available in the Field Explorer.

DataDate is a CR function. Either choice displays the last date that the report was refreshed.

For more information about DataDate, search for article c2008954 at:

http://support.businessobjects.com/search/

====================

More Information:

For more information on Crystal Reports functions, refer to the Crystal Reports Online Help by pressing the 'F1' key and serach for the required function.

Keywords

PRINTDATE CURRENTDATE DATADATE DIFFERENCE DATE FUNCTIONS SPECIAL FIELDS Crystal Reports Date functions and Special Fields Formula , c2016058 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

SAP Crystal Reports 10.0