SQL Request Controls not displaying data when using current date common reference
- Last updated
- 05:14, 22 Mar 2017
Save as PDF
When using the Current Date Common Reference in a query for the SQL Request Control no data is returned
SolutionUse the formatdate runtime function in either a calculated value control or a Form Variable to change the date to a format understood by SQL.