topic Re: Date simple year function does't work (why) in QlikView

Date simple year function does't work (why)

Mon, 05 May 2014 22:00:28 GMT

Hi Below is my script. Confused as to why Year or month function does not work, gives me syntax error. Date is in correct format.

Load *,

[Closed Date] - [Create Date] as no_of_days_to_solve;

LOAD

[Ticket Number],

[Requestor Name],

[Support Group],

[Call Summary],

[Call Status],

[Call Severity],

[Call Type],

[Create Date],

Year [Create Date] as year, // I get syntax error here. I have tried month no luck.

[Closed Date]

FROM

.......

(biff, embedded labels, table is Sheet1$);

Re: Date simple year function does't work (why)

swuehl — Mon, 05 May 2014 22:05:34 GMT

Try using the Year function with brackets:

Year( [Create Date] ) as year,

Re: Date simple year function does't work (why)

suheshreddy — Tue, 06 May 2014 03:11:44 GMT

Try using this

Year(Date( Date#([Create Date],'MM,DD,YYYY' )'MM,DD,YYYY' ))as year

Re: Date simple year function does't work (why)

jagan — Tue, 06 May 2014 03:43:21 GMT

Hi,

You missed brackets () for the Year function, try like this

Load *,

[Closed Date] - [Create Date] as no_of_days_to_solve;

LOAD

[Ticket Number],

[Requestor Name],

[Support Group],

[Call Summary],

[Call Status],

[Call Severity],

[Call Type],

[Create Date],

Year([Create Date]) as year,

[Closed Date]

FROM

.......

(biff, embedded labels, table is Sheet1$);

Regards,

Jagan.