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

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

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
 
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:D[email protected]...
 
the regional format for date is dd/mm/yyyy


Ο χÏήστης "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
 

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

extract just month/year from table field?? 2
Format Date "dd/mm/yyyy" 1
create input mask "yyyy-mm-dd" 5
Formatting date gives bad results in query 2
convert a date 4
ccyymmdd to dd/mm/yyyy from query 2
Date Function in query 3
calculate Age problem date notation european american format 2

Back
Top