2 Replies Latest reply on Jan 17, 2018 1:28 PM by michaelfr RSS
    michaelfr Creator

    Reference Current Date in SQL Query



    I'm trying to reference the current date when having a SQL query perform. I have my service setup as a SQL (Query) and I have the following code.


    Select Result, Result_On from Tests where Var_Id = '20903' ORDER BY Result_On DESC


    I'm looking to have the query only pull results where Result_On is equal to the current date (today's date), however I can't seem to figure out how to make the query reference the current date.


    Any help would be greatly appreciated.