Convert a date into months

[mahendragaur]

Hello Users,

I'm importing one of the .csv file into QlikView. The data source contains one column in format " 3/21/2016 12:00:00 AM" but I want only month from the mentioned date. I'm using month() function to fetch only months and that I am using every time but it didn't work. Could any one please tell me what may be reason that month function is not working.

below is the script I'm using -

LOAD //WorkCenter_Operation_Desc_Op_No_Key & '-' & SHOP_ORDER & '-' & Num([End Date]) AS CompositeKey,
  //WorkCenter_Operation_Desc_Op_No_Key,
   //SHOP_ORDER,
   Month([End Date]) as Month1, 
[LT(hrs)]
FROM
//[$(vExcel_Folder)\ChartData.csv]

(txt, utf8, embedded labels, delimiter is ',', msq, filters(
Remove(Row, Pos(Top, 2))
));

[stonecold111]

  thanks

[mahendragaur]

Thank you Sunny.. Perfect answer. It worked

[stonecold111]

plz make sunny's as correct answer as it would help others