ID: Q98928
The information in this article applies to:
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.
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.
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.
11. Choose OK twice.
12. From the Report menu, choose Page Preview.
The DATE() field in the Page Header will also be formatted to the British date.
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.
Additional reference words: FoxDos 2.50 2.50a American multiple KBCategory: kbprg kbprb KBSubcategory:
Last Reviewed: April 17, 1995