topic Date Issue in QlikView

Date Issue

Thu, 10 Mar 2011 14:47:45 GMT

I have a date field that is formatted YYYY/MM. When I run the Year(Field) As Year I get some screwy number. Is there a formula I should be using to be able to parse the year out? Interestingly enough, the Month(Field) as Month works fine.

Any suggestions?

Date Issue

Miguel_Angel_Baeyens — Thu, 10 Mar 2011 14:59:51 GMT

Hello,

I'd use the following to extract the proper date and year or month from it

Year(Date#(Field, 'YYYY/MM')) AS Year,Month(Date#(Field, 'YYYY/MM')) AS Month

Hope that helps.

Date Issue

IAMDV — Thu, 10 Mar 2011 15:00:26 GMT

Quick Solutions : Left(DateColumn,4)

Date Issue

Thu, 10 Mar 2011 15:26:42 GMT

Thank you....is there any additional scripting needed like AS

Date Issue

Miguel_Angel_Baeyens — Thu, 10 Mar 2011 15:37:59 GMT

It is, as I wrote above, the example to be added to your actual script.

Table:LOAD Field, Month(Date#(Field, 'YYYY/MM')) AS Month, Year(Date#(Field, 'YYYY/MM')) AS YearFROM file.qvd (qvd); // your datasource here

Hope that helps