VBA SQL query from Excel compare date time, convert date

SQL query stores date from Excel file as General format,

Then to query you need:

  1. Convert date column in the source file to General
  2. In the query you use CDBL to convert criteria to double

 

Leave a Reply