9 Replies Latest reply: Apr 7, 2014 10:21 AM by Kevin Rovers RSS

    Date in SELECT statement - QV script

      Hi all,

       

      I'm stuck with a problem.

       

      I want to use the current date (7-4-2014) in my SELECT statement.

       

      Codetracker:

      SQL

      SELECT

      Code,
      Count(Code) as aantal,
      CurrentDate() as afldatum
      FROM DATASTORE.dbo."DS_ORDRS"

      WHERE Code not in (0,99)

      ;

       

      I have searched on the internet to find the solution, but all I can find is how to use date outside QV script, or in the WHERE statement in SQL script.

       

      Anyone know how I can solve this?