I have a procedure that inserts a record including a date into an Access database. If the dd portion of the date can equate to a month then the dd and mm parts of the date are switched otherwise the date remains as is. eg 12/11/2007 is being stored as 11/12/2007 but 13/12/2007 is stored as 13/12/2007. I can code round this but surely the rules should be consistent. The insert statement is INSERT INTO ACCTRANSFER VALUES (" & MaxHeaderID & ", " & intAccFromCode & ", " & intAccToCode & ", " & Val(Me.txtAmount.Text) & ", #" & CDate(Me.txtTransferDate.Text) & "#)". Can anyone throw any light on this please.
January 20, 2009 4:54 PM
January 21, 2009 8:25 PM