Preferences - Date Display Format
Use the Date display format tab of the Preferences dialog to choose the display format for date fields in the assets Database.
To use the current date format settings for your PC:
1 In the File menu, choose Preferences. The Preferences dialog is displayed.
2 Select the Date display format tab.
3 Select Default format.
4 Click OK to close the dialog and save your changes.
5 In the Query menu of the assets database, choose Execute SQL to display the dates in the new format.
To specify a date format for assets database:
1 Select Custom.
2 Enter the date format in the Custom field. The date format is set using the standard Microsoft convention. For example,to display the date in the form 26 October 2004, enter dd-mmmm-yyyy.
3 Click OK to close the dialog and save your changes.
4 In the assets database Query menu, choose Execute SQL to display the dates in the new format.