Preserving date format

  • Thread starter Thread starter mohd21uk via AccessMonster.com
  • Start date Start date
M

mohd21uk via AccessMonster.com

I have imported a table from Microsoft Excel. This table has the date set in
the mm/dd/yyy format. However, the table recognises the date in the
dd/mm/yyyy format nad changes the format to accommodate this. Is there any
way I can change this so that the format stays mm/dd/yyyy ?
 
First check your Windows Regional settings in the Control Panel. If they
need to stay that way, it may be as simple as setting the field format in
the Access table. If that doesn't help, run an update query after the
import:

UPDATE MyTable SET MyTable.[DateField] = Format([DateField],"mm/dd/yyyy");
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
That worked fine thanks
First check your Windows Regional settings in the Control Panel. If they
need to stay that way, it may be as simple as setting the field format in
the Access table. If that doesn't help, run an update query after the
import:

UPDATE MyTable SET MyTable.[DateField] = Format([DateField],"mm/dd/yyyy");
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
I have imported a table from Microsoft Excel. This table has the date set in
the mm/dd/yyy format. However, the table recognises the date in the
Click to expand...
[quoted text clipped - 3 lines]
Click to expand...
 
Back
Top