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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
When exporting data that needs formatting, use a query to do the formatting.
You then export the query rather than the table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text to date format? 0
Excel date format YYYYMMDD 1
How to change yyyymmdd number field to a date field 3
Custom Date Format 2
Format of text date 4
Changing Date Format in Query to Export Data 8
how do I convert date format yyyymmdd to mm/dd/yyyy 2
Changing date in number format to dd/mm/yyyy? 5

Back
Top