This is the only way I can find to ensure that a UK date is formated correctly for any kind of database interaction.

Use:

SetLocale( “English (UK)” );
LSParseDateTime( date );
createODBCDate( date );

SetLocale( "English (UK)" );
dteDate = createODBCDate( lsParseDateTime( form.dteDate ) );
SELECT dteDOB FROM tbluser WHERE dteDOB = #dteDate#;