convert date format from mm/dd/yyyy to dd/mm/yyyy

[Guest]

i have a field that contain date like mm/dd/yyyy and i need to convert to
dd/mm/yyyy, in new record in query

 

[Allen Browne]

Access stores the dates as a numeric value, with no format.

The format is applied at display time, depending on the Regional Settings of
the user. Set the correct settings in the Windows Control Panel, under
Regional Options, and Access will display the date in that format.

For more details, see:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news[email protected]...

 

[Guest]

the regional format for date is dd/mm/yyyy


Ο χÏήστης "Allen Browne" έγγÏαψε:

 

[Allen Browne]

In that case, the date is stored incorrectly (unless the Format property is
set in the text box or in the field properties in table design.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message