Preserving date format

[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 ?

 

[Arvin Meyer [MVP]]

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

 

[mohd21uk via AccessMonster.com]

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

[quoted text clipped - 3 lines]