5 Replies Latest reply: Jan 4, 2011 3:44 AM by christophwimmer RSS

    Problems with Year() Function

    christophwimmer

      Hello to everybody,

      I'm new with qilikview and trying to make my first project.

      I import data from an firebird database via ODBC. When adding the Year function (as stated below) the script makes an error:

      SQL##f - SqlState: HY000, ErrorCode: 4294967192, ErrorMsg: [ODBC Firebird Driver][Firebird]Dynamic SQL Error
      SQL error code = -104
      Token unknown - line 3, column 5
      Year
      SQL SELECT ID,
      DATUM,
      Year(Datum) as Jahr,
      WAEHRUNG,
      "WAEHRUNG_KURS",
      "MWST_SATZ",
      "GESAMTSUMME_NETTO",
      HEADER,
      "HAUPT_ID",
      "BEZAHLT_BRUTTO"
      FROM "V_RECHNUNG"

       

      I'm afraid I make a very trivial mistake but I don't know where and why? Datum is a timestamp format and without the year function the script works!

       

      Thanks for every help!!!

       

      Christoph