Inserting Dates



  1. To add a date field, you need to insert a special field. You can open the Field Explorer dialog box by using either the Insert menu or the toolbar button. In this example, you will use the toolbar button.


    Click the Field Explorer button.

    Step 1
  2. The Field Explorer dialog box contains a list of the fields available to add to the report.


    Open the Special Fields folder.


    Click the expand button.

    Step 2
  3. There are several types of date fields that can be inserted, such as Data Date, File Creation Date, Modification Date, and Print Date. In this example, you are going to use the Data Date, which is the date in which the data was last refreshed on the report.

    Step 3
  4. There are three ways you can add a field to a report: double-click it and place it in the report, click and drag it to the report, or click the field and click the Insert to Report button. In this example, you will double-click the field.


    Double-click the Data Date list item.

    Step 4
  5. Click the Report Header section of the report to place the date field in the header of the report.


    Click the Report Header cell.

    Step 5
  6. Click the Close button.

    Step 6
  7. Next, view the results.


    Click the Refresh button.

    Step 7
  8. Notice the date field in the report. The date in the report is updated each time the report is run. The date is based on the system date on your computer.

    Step 8

You have successfully inserted a date field in a Crystal report.

Table of Contents  Start Topic