Convert Dates from MM / DD / YY to DD / MM / YY

<i><b>Originally posted by : mark raassens (mark.raassens@12move.nl)</b></i><br /><br />Hi all,<br /><br /><br />I'm having this problem...<br />I'm living in the netherlands, and we use the uk-date-format like: DD/MM/YYYY.<br /><br />I know almost all os's and databases use the US-format to store their dates in the database.<br /><br />The one thing is, that i've set up my access database using the UK-format ( DD/MM/YY )<br /><br />The problem is when i want to add something to the database, and enter a date in textbox on a form in uk-format ( DD/MM/YY ) The date gets inserted in the US-format, and then the date isn't right anymore...<br /><br />I noticed that the SQL-statement I'm using is causing this as SQL only uses US-formats.. <br /><br />Questions is, <br />Is there somekind of function which converts my originally UK-format date to an US-format date, so that my sql-statement inserts the right values into the database.. <br /><br />I made some function myself, but this is not good... What if someone enters a date like 1/2/01 because my function assumes that the user always types 2 characters for both day and month.. even if it's only one character...<br /><br />strMM = Mid(strUSDate, 1, 2)<br />strDD = Mid(strUSDate, 4, 2)<br />strYY = Mid(strUSDate, 7, 2)<br /><br />strUKDate = strDD & "/" & strMM & "/" & strYY<br /><br /><br />but this isn't just what i'm looking for...<br /><br />Any ideas ??<br /><br />Any help will be appreciated..<br /><br />Thanks in Advance..<br /><br />Mark Raassens

<i><b>Originally posted by : Brian Ty (brian.ty@epiphany.com)</b></i><br /><br />Hi Mark,<br /><br />why not try using the date functions when working with US dates?<br /><br />ex:<br /><%<br />'US Date<br />strUS = DateValue(Now())<br /><br />'Construct UK date<br />strUK = Day(strUS) & "/" & Month(strUS) & "/" & Year(strUS)<br /><br />%><br /><br />good luck.<br />-brian<br />------------<br />mark raassens at 1/29/2001 10:50:59 AM<br /><br /><br />Hi all,<br /><br /><br />I'm having this problem...<br />I'm living in the netherlands, and we use the uk-date-format like: DD/MM/YYYY.<br /><br />I know almost all os's and databases use the US-format to store their dates in the database.<br /><br />The one thing is, that i've set up my access database using the UK-format ( DD/MM/YY )<br /><br />The problem is when i want to add something to the database, and enter a date in textbox on a form in uk-format ( DD/MM/YY ) The date gets inserted in the US-format, and then the date isn't right anymore...<br /><br />I noticed that the SQL-statement I'm using is causing this as SQL only uses US-formats.. <br /><br />Questions is, <br />Is there somekind of function which converts my originally UK-format date to an US-format date, so that my sql-statement inserts the right values into the database.. <br /><br />I made some function myself, but this is not good... What if someone enters a date like 1/2/01 because my function assumes that the user always types 2 characters for both day and month.. even if it's only one character...<br /><br />strMM = Mid(strUSDate, 1, 2)<br />strDD = Mid(strUSDate, 4, 2)<br />strYY = Mid(strUSDate, 7, 2)<br /><br />strUKDate = strDD & "/" & strMM & "/" & strYY<br /><br /><br />but this isn't just what i'm looking for...<br /><br />Any ideas ??<br /><br />Any help will be appreciated..<br /><br />Thanks in Advance..<br /><br />Mark Raassens