This weeks Tip: Set Date Format Correctly for Accurate Information.
 
AdvantageX6 uses the Day , Month, Year (dd/mm/yyyy) format for reporting and displaying information.
This is the most common format used in South Africa and many of the reports in Advantage are formatted and queried by using this date format.
 
If your system date format is not setup correctly this may cause problems when typing in dates as any dates entered may be converted depending on your system date format setting.   E.G.  12/07/2009 (12 July) may be converted to 07/12/2009 (7 December) if the date format is not set correctly.
 
To correct this do the following:
1.  Click Start
2.  Click Control Panel
3.  Double-Click on the Regional and Language Options setting.
4.  Click on the Customize button.
5.  Click on the Date Tab.
6.  Next to Short Date Format enter the value:   dd/mm/yyyy
7.  Thereafter click on the Apply button.
8.  Then Click on OK
9.  Then click on the Apply button again.
10.  Then click on OK.
 
This will format your date correctly and not convert dates by itself.
Your management reports will then print the correct information based on the accurate input of your dates.
 
Past Tech Tips Review.   
1.  How are your backup plans going, and have they been executed successfully? 
2.  Do you know how to get the most benefit from your FREE telephonic support? 
3.  Have you considered upgrading to SQL Advantage V7 for reliability and performance? 
4.  Are you and/or your users updating and using AdvantageX6 on a daily basis?