PRB: Reports Incorrectly Format Non-British Date Fields

• Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, and 2.5a

SYMPTOMS

When you are using both British and non-British date formats in a single report, the first occurrence of the non-British date field will be incorrectly formatted with the British date format.

If a non-British date field is in the report Page Header and a British formatted date field is anywhere else in the report, the date field in the Page Header will also be formatted with the British format.

RESOLUTION

To keep the non-British date format intact in these instances, select the first non-British date in the report, press ENTER twice, choose Format, and select Edit "SET" Date under Editing Options.

This formatting option must also be selected for the first Detail line where both British and non-British DATE() fields reside.

MORE INFORMATION

Steps to Reproduce Problem

1. Open a database.

2. In the Command window, type:

   CREATE REPORT TESTDATE

3. From the Report menu, choose Field.

4. In the Expression box, type the following and choose OK.

   DATE()

5. Move the DATE() field in the Report Layout window to the Page Header.

6. Select the DATE() field, and choose Copy from the Edit menu.

7. Place the cursor on the first Detail line.

8. From the Edit menu, choose Paste.

9. Press ENTER twice to open the Report Expression dialog box.

10. Choose Format and select British Date under Editing Options.

11. Choose OK twice.

12. From the Report menu, choose Page Preview.

If a Detail line has both date formats on it, both dates will be formatted to the British dates. All other non-British date fields in the report will be formatted correctly.