hi i am using vb.net 2008 and access
i want the date to b stored in dd/MM/yyyy format

in the main startup prog. i have given this
Code:
        Thread.CurrentThread.CurrentCulture = New Globalization.CultureInfo("en-GB")
this allows me to enter the date in dd/MM/yyyy format even where the system date is otherwise..
but my prob is if someone types the date 01/04/2008 and is stored by me in the access using the following :

Code:
mCmd = "INSERT INTO RegApplication "
            mCmd = mCmd & " (AppDate)"
  mCmd = mCmd & " VALUES "
 mCmd = mCmd & " (@mAppDate)"
cmd = New OleDbCommand(mCmd, MyConConnection)
cmd.Parameters.AddWithValue("@mAppDate", OleDbType.Date).Value = Format(dtPkAppDate.Value, "dd/MM/yyyy")
even then when the data is displayed it is shown as 04/01/2008..i.e. it takes 01 to b the month and 04 to b the date ...only at places where the system date is not as dd/MM/yyyy but if the system date is dd/MM/yyyy then the date is displayed correctly.

pls. help me out..
thankx