[Access] Find Dates format

My colleague just asked, have to repeat again: correct format for date in Filter method for ADODB recordset and SQL server is 'yyyymmdd', in single quotes. HTH!