the date format from forms per pc definitions is passed to sql as text, so you need to convert to the string version of the us date format, or you can used the cdate function to convert the string (per local pc requirements to a date datatype. The issue with the latter is that being a vba function, you cannot pass it to sql server or other rdbms's - at least not without a big performance hit - so better to convert to the universal (i.e US) string format which is recognised pretty much everywhere.