Storing Dates in the same format (yyyymmdd) in different pc's

L

Leon

The date format seems to change when i install the application on another Pc.
This causes problems as i need to export this field in the yyyymmdd format.
Cheers
 
K

KARL DEWEY

A true DateTime datatype field all store the same way but are displayed in
many ways. The display on the computer can be set differently.

Go to START - Control Panel - Regional And Language Options. Then Regional
Options - Customize - Date and change the display for the date.

OR just set the Format of your output in the form or report.
 
P

Pat Hartman \(MVP\)

When exporting data that needs formatting, use a query to do the formatting.
You then export the query rather than the table.
 
Top