topic Re: how to get year from date in QlikView

how to get year from date

Tue, 04 Jun 2013 17:30:35 GMT

How to get year from date:

I am have the order_date colum in a table(like 07/20/1987), I need them to be in years. how can i get the years from dates? please help me with this.

Thank u.

er_mohit — Tue, 04 Jun 2013 17:35:06 GMT

Try this

Date(DateField,'YYYY') as Year or this way

date(date#(DateField,'MM/DD/YYYY'),'YYYY') as Year or simply write

Year(DateField) as Year

hope it helps

Tue, 04 Jun 2013 18:40:43 GMT

tried all nothing worked.

i am having the order date in orders table and quantity in order details table.

i joined the two by left join

Tue, 04 Jun 2013 18:46:27 GMT

Order date formate is like this:

1996-07-05 00:00:00.000

1996-07-08 00:00:00.000

1996-07-09 00:00:00.000

1996-07-10 00:00:00.000

how can i get the year out of this,please help

Gysbert_Wassenaar — Tue, 04 Jun 2013 18:53:54 GMT

num#(left(MyDate,4)) as Year

or year(date#(MyDate, 'YYYY-MM-DD hh:mm:ss.fff')) as Year

er_mohit — Tue, 04 Jun 2013 18:59:56 GMT

Write this in script where is your order date field

year(Date#([Order Date],'YYYY-MM-DD hh:mm:ss.hhh')) as Year

MayilVahanan — Tue, 04 Jun 2013 19:46:20 GMT

Try like this

Load *,

year(Date#([Order Date],'YYYY-MM-DD hh:mm:ss.hhh')) as Year

From tableName;