im using the access database and didn&#039t set any date format of this date of birth fields in access. i use to_char(....) ,in the sql statement and dsiplay error message : syntac error "insert into statement" i try not using the to_char format and successful execute it, but in the access database and edit screen page it come the month first tehn day,3/1/00 as user input 01-mar-00 why? how to set the date format in sql?<BR><BR>SQLStmt ="insert into Agent_Master(Agent_ID,Agent_Name,Upline_Agent_ID," &_ " Level_Code,Position_Code,Break_Away,Agent_IC,Agent _Passport,to_char(Date_Of_Birth,&#039dd-mon-yy&#039),Sex,"&_....<BR><BR><BR>