how to extract data using "date" filter

[#1]

FAX:

SQL SELECT

    ID,

    DATE,

    ACCOUNTNAME,

    DOCNAME,

    PAGECOUNT,

    DURATION,

    PHONENUMBER

FROM DB."FAX";

store FAX into FAX.qvd (QVD);

loading from *.qvd is very easy

FAX:
Load
    ACCOUNTNAME,
     PAGECOUNT,
     DATE,
     year(DATE) as YEAR,
     MONTH(DATE) AS MONTH,
     Day(DATE) as DAY,
     MONTH(DATE) & year(DATE) as Mo_Ye

     FROM [..\FAX.qvd]
(qvd);

======

DATE

Data_Type     = SQL_Timestamp (11)

Type Name    = Date

Column_Size  =19

Buffer-Lengt    =16

etc...

========

because of a very large amount of data, extracting without filtering by year is very difficult and time consumption.

please help me to find out a solution:

"where  year(date)=2015"                  =YEAR: invalid identifier

"where year[(date)=2015] "                =invalid relational operator

"where date(trxdate)=31/12/2014"     =missing expression

[Anonymous]

try this:

FAX:
Load
    ACCOUNTNAME,
     PAGECOUNT,
     DATE,
     year(DATE) as YEAR,
     MONTH(DATE) AS MONTH,
     Day(DATE) as DAY,
     MONTH(DATE) & year(DATE) as Mo_Ye

     FROM [..\FAX.qvd]
(qvd) where year(DATE)=2015;

[#3]

Thank you very much!

but I want to filter data from the beginning, not after I store them in FAX.QVD and load from...

ODBC CONNECT TO[..... ] (UserId is..., Password is ...);

FAX:

SQL SELECT

    DATE,

...

...

...

FROM DB."FAX";

store FAX into FAX.qvd (QVD);

[Anonymous]

In case of Date, try this:

FAX:
Load
    ACCOUNTNAME,
     PAGECOUNT,
     DATE,
     year(DATE) as YEAR,
     MONTH(DATE) AS MONTH,
     Day(DATE) as DAY,
     MONTH(DATE) & year(DATE) as Mo_Ye

     FROM [..\FAX.qvd]
(qvd) where date(DATE,'DD/MM/YYYY')='31/12/2014';   

[#5]

missing expression

[#6]

I need data filter from the beginning not after I load from FAX.QVD

ODBC CONNECT TO[..... ] (UserId is..., Password is ...);

FAX:

SQL SELECT

    DATE,

..........................

FROM DB."FAX";

store...