how to extract only records from a particular year

[#1]

Hi, how do I extract records for the year 2012 based on a column with the datatype 'DD/MM/YYYY hh:mm:ss'?? Thanks.

[senpradip007]

Try this,

Load

     *

From <Source Table>

where Year(DateTime) = 2012;

[#3]

Hi, apparently i cant use year(Field) = 2012. this is what i did:

sql select

.

.(other fields)

.

statusdate.

.

.

from <filename> where year(statusdate)=2012;

an error message stated that 'year' is an invalid identifier...

How to extract particular year and find the column with the earliest date?

[senpradip007]

Can you upload sample qvw?

[jonathandienst]

Hi

This is because everything after the SQL command is executed by the database server, not by Qlikview. If you are using MS SQL Server, then the command would be

     WHERE DatePartr(yy, statusdate) = 2012

Other databases would need a different expression.

HTH

Jonathan

[jagan]

Hi,

Try like this

LOAD

*

WHERE Year(statusdate) = 2012;

sql select

.

.(other fields)

.

statusdate.

.

.

from <filename> ;

Regards,

Jagan.

[Anonymous]

Try below,

LOAD *

WHERE Year(statusdate)=2012;

SELECT *

FROM <filename>;

Thanks