topic Date/ Year/ Month... Help in QlikView

Date/ Year/ Month... Help

Tue, 08 May 2012 15:51:31 GMT

I have a Field that lists the Invoive Dates for past sales as YYYYMMDD. I was successfully able to convert it to MM/DD/YYYY by:

Date(Date#([Invoive Date]),'YYYYMMDD'),'MM/DD/YYYY') as [Invoice Date]

But, when i try to use the Year or Month Functions 01/05/2009 returns as:

Month: November Year 56904

How can I correct this?

Thank you!

Tue, 08 May 2012 16:36:00 GMT

Year(MakeDate(Left(DATE,4),Mid(DATE,5,2),Mid(DATE,7,2))) as [Year],

Month(MakeDate(Left(DATE,4),Mid(DATE,5,2),Mid(DATE,7,2))) as [Month],

Day(MakeDate(Left(DATE,4),Mid(DATE,5,2),Mid(DATE,7,2))) as [Day],

I have helped

rwunderlich — Tue, 08 May 2012 16:49:59 GMT

Can you post the expression you are using?

Year(Date#([Invoive Date]),'YYYYMMDD')) as [Invoice Year]

should work.

Tue, 08 May 2012 17:06:01 GMT

Rob: That worked! THANK YOU!

Tue, 08 May 2012 17:17:17 GMT

I need your help Mr Rob, will U?

Regards

Sagar Gupta