topic Script issue with Microsoft Excel Date field in QlikView

Script issue with Microsoft Excel Date field

Thu, 13 May 2010 15:08:06 GMT

My data source is an Excel spreadsheet. One of the columns (Policy Date) is define as a date field in MM/DD/YYYY format.

In my script I'm trying to perform

Month([Policy Date]) as Month

and

Year([Policy Date]) as Year

to no avail.

What do I need to do to extract the month and year from an Excel date field?

Thu, 13 May 2010 15:32:22 GMT

hi,

you can use the following code

tab1:

LOAD date#([Policy Date],'MM/DD/YYYY ') as [Policy Date];

LOAD [Policy Date]

from ......abc.xls;

tab2:

load year([Policy Date]) as year,

month([Policy Date]) as month

resident tab1;

hope that it should work

thanks

boorgura — Thu, 13 May 2010 16:04:21 GMT

Richard,

Please try this:

Month(Date([Policy Date]) as Month,

Year(Date([Policy Date]) as Year

Let me know if it works or not.

Thu, 13 May 2010 18:05:38 GMT

Thanks Rocky. Did the job.