When using the Current Date Common Reference in a query for the SQL Request Control no data is returned.
Use the formatdate runtime function in either a calculated value control or a Form Variable to change the date to a format understood by SQL.
The Date format returned by the Current Date Common Reference is:
DayOfWeek, Month DD, YYYY, TIME
SQL does not understand this format. To convert this to an alternate format the formatdate runtime function can be used:
Syntax: FormatDate(DATE, Format)
Example Usage: FormatDate(CurrentDate, "MM/dd/yyyy")
For a full list of the date formatting that can be applied, see Date and Time Format Strings - Quick Reference Guide