7 Replies Latest reply: Mar 23, 2011 4:06 PM by Triggerxi77 RSS

    Error using Year() function into a SQL SELECT statement

      Hi.

      I have tried to use the Year function into a SQL SELECT statement. I'm using QV 10 SR1.

      I have written:

      Tbl1:

      LOAD Year(myDate) as YYYY

      SQL SELECT Year(myDate) FROM myDB.dbo.myTable

      STORE Tbl1 INTO c:\qvapp\myTables.QVD

      and I have myDate field not found error.

      Any helps to me, please? Thanks