Thanks, Kaushik. I tried your solution, but experienced the following issues:
If I use single quotes ( ' ') around the '$(vDate)' in my SQL, it fetches zero records. The syntax check gives the appearance that it does not recognize it as a variable (not italicized or in gray like other variables. Example: $(vLastQtrDate6).
If I do not use single quotes $(vDate) for my date criteria, the script returns an error that an expression is missing. When I scroll to the date portion of the where clause in the SQL statement, the date is blank.
Any other thoughts? I suspect that using a variable will work. I just don't have the right date format. I would send a QV sample, but it would be time-consuming to recreate.
Should I perhaps use single quotes in place of either of the double quotes in the let vDate formula?