How to convert a timestamp column in Year YYYY format?

[Anonymous]

Hi,

I tried using the YEAR() function but I am not getting any records.

I imported an excel file in my qlikview and I wanted to extract year from a timestamp column, but I am unbale to do so.

What could be the error?

PFA screenshot

I want to Year from the ORDERED DATE list box,

for example

2014

2015

2016

Thanks

[its_anandrjs]

You can try this also

Year( DISTINCT Date(Date#([Ordered Date], 'DD/MM/YY hh:mm TT'),'YYYY') )