Skip to main content
Search Again

We think these articles could help you:

    See More
    Nintex Knowledge Base

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

    Status: Validated

    ISSUE
    When using the Current Date Common Reference in a query for the SQL Request Control no data is returned.
    ERROR CODE
    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
    RELATED LINKS
    • Was this article helpful?