How to insert new field as Months Name based on Date?

[#1]

I want to insert another field as Month and it should contain only month names based on dates given in Date of Sales field. And this [Date of Sales] filed in MM/DD/YYYY format.

How to insert this field. Please any one help me.

[Case Study 3]:

LOAD Customer_id as [Customer ID],

     Customer_name as [Customer Name],

     Subsegment,

     City,

     Division,

     Category,

     Version,

     Sales_amount as [Sales],

     No_of_Licences as [Licenses],

    Sales_Date as [Date of Sales]

  FROM

Sales1.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

[jagan]

Hi,

Try like this

LOAD

*,

Month(Date#(Sales_Date, 'M/D/YYYY')) AS Month

FROM SourceData;

Regards,

Jagan.

[#3]

Finally got it. Thank You so much Anand, Sundarkumar and kushal.. I really appreciate ur help

[its_anandrjs]

If you got correct answer so mark the thread as Correct / helpful for other reference.

Regards