Hi I have come across a problem which I cant seem to resolve so hopefully one of you guys will be able to help me.My database has a field for date_entered and is a DateTime field. My script pulls in the current date and formats it to dd/mm/yyyy. Now todays date is 06/03/2006, I do a response write for DATE() in my browse and it shows up as 06/03/2006 but when it goes into my database it shows up as 03/06/2006. Now if I was to put 13 where 06 is it will then turn into 13/03/2006.Does anybody know why it does this and what I can do to fix it, below is my script.<%session.lcid=2057' Declaring variablesDim prefix, lastname, phone, dem, date_entered, data_source, con, sql_insert' A Function to check if some field entered by user is emptyFunction ChkString(string)If string = "" Then string = " "ChkString = Replace(string, "'", "''")End Function' Receiving values from Formprefix = ChkString(Request.Form("prefix"))lastname = ChkString(Request.Form("lastname"))phone = ChkString(Request.Form("phone"))dem = ChkString(Request.Form("dem"))'date_entered = ChkString(Request.Form("date_entered"))'strDateTime = formatDatetime("%d, %m, %y", Date())Response.Write(date())'Create the data sourcedata_source = "DSN=***;UID=***;PWD=***;DATABASE=***"'SQL statement to insert values into the designated columssql_insert = "insert into contact (prefix, lastname, phone, dem, date_entered) values ('" & _prefix & "', '" & lastname & "', '" & phone & "', '" & dem & "', '" & date() & "')"' Creating Connection Object and opening the databaseSet con = Server.CreateObject("ADODB.Connection")con.Open data_sourcecon.Execute sql_insert' Done. Close the connectioncon.CloseSet con = Nothing%>
DateTime not working properly
Posted - 2006-03-06 : 05:11:36
