Date simple year function does't work (why)

[#1]

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$);

[swuehl]

Try using the Year function with brackets:

Year( [Create Date] ) as year,

[suheshreddy]

Try using this

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

[jagan]

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.