cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Request Controls not displaying data when using current date common reference

Issue

When using the Current Date Common Reference in a query for the SQL Request Control no data is returned.

 

Resolution

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.

 

Additional Information

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

 

Version history
Revision #:
1 of 1
Last update:
‎12-31-2020 08:32 PM
Updated by:
 
Contributors