How to write a SQL statement in VB6

I am trying to create a report in VB6 where the the user picks 2 different dates and the results are then sent to a datareport to be printed. My problem is I do not know how to incorporate my user defined dates into the SQL Statement. Nor do I know the proper syntix for manualy writting it into the commaned buttion or how this would be accomplished using the SQL builder.