Date Conversion

[jurgen]

Hi,

How can I convert a dd/mm/yyyy field tot a mm/dd/yyyy field, if i enter 20/03/2001 and I use this in my sql statement, it won't work but if i type 03/20/2001 then
it works ?

How can i manipulate it so that the user can enter 20/03/2001 ... any suggestions


Jurgen

 

[JoeMiller]

You could use a dummy control for entering the data and have the value of that control converted to your MM/DD/YYYY format on the AfterUpdate event of the dummy control. To convert you would use the Left(), Right(), and Mid() functions to convert the data. I answered a similar question in the Access General Discussion area, here's the link to that:

thread181-80901 me know if you have any questions!

Joe Miller
joe.miller@flotech.net

PS - Can someone tell me how I would have posted that link so they could just click it instead of Copy/Paste??

 

[rhicks]

Simply use the Format function in your SQL statement to convert your date to the needed format on the fly.



HTH
RDH Ricky Hicks