Changing date format on Financial Reports
Posted: January 24th, 2012, 8:18 pmC21 allows you to present dates on financial reports in one of two formats:
C21 uses the long and short date styles from your Windows settings.
In Windows you can select from a number of Long and Short date styles with Start/Settings/Control Panel/Regional Settings, and click the Date tab.
To select either the Windows long or short date format on a C21 financial report, you modify the report:
1. Click General Ledger on the C21 menu bar.
2. Run Configure/Financial Reports.
3. Open the folder for the type of report you want to modify (i.e., Balance Sheet, Income Statement, Trail Balance, Cash Flow).
4. Double-click the report you want to modify.
5. Highlight the heading or column you want to modify.
6. Right-click to view the options menu and click Modify or press F2.
7. Highlight the substitution string for date (%A for Short as of date, %A1 for Long).
8. Right-click to view the print options.
9. Highlight “As of Date” to view the date format options.
10. Select Short or Long, click OK, and save the changes.
Select “Period” in Step 9 to change the format of period and year start and end dates.
How can I change the date on my financial reports from "Sunday December 31, 2006" to "December 31, 2006", for example?
1. Go into Control Panel\Region and Language Options.
2. Click on “Customize” under the “Regional Option” tab. This brings up the “Customize Regional Options” screen.
3. Click the “Date” tab.
4. Go down to the “Long Date Format” and select “MMMM DD, YYYY”.
- Long
- Short
C21 uses the long and short date styles from your Windows settings.
In Windows you can select from a number of Long and Short date styles with Start/Settings/Control Panel/Regional Settings, and click the Date tab.
To select either the Windows long or short date format on a C21 financial report, you modify the report:
1. Click General Ledger on the C21 menu bar.
2. Run Configure/Financial Reports.
3. Open the folder for the type of report you want to modify (i.e., Balance Sheet, Income Statement, Trail Balance, Cash Flow).
4. Double-click the report you want to modify.
5. Highlight the heading or column you want to modify.
6. Right-click to view the options menu and click Modify or press F2.
7. Highlight the substitution string for date (%A for Short as of date, %A1 for Long).
8. Right-click to view the print options.
9. Highlight “As of Date” to view the date format options.
10. Select Short or Long, click OK, and save the changes.
Select “Period” in Step 9 to change the format of period and year start and end dates.
How can I change the date on my financial reports from "Sunday December 31, 2006" to "December 31, 2006", for example?
1. Go into Control Panel\Region and Language Options.
2. Click on “Customize” under the “Regional Option” tab. This brings up the “Customize Regional Options” screen.
3. Click the “Date” tab.
4. Go down to the “Long Date Format” and select “MMMM DD, YYYY”.