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

  • 26 March 2021
  • 0 replies
  • 29 views

Badge +8

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

 


0 replies

Be the first to reply!

Reply