23 Replies Latest reply: May 18, 2017 9:10 AM by Yeo Poh sai RSS

    How to create a YearMonth from date field ?

    Yeo Poh sai

      Hi All

       

       

      I have below script , i need to create a field name YearMonth from DATE.

       

       

      Hope some one can advise me. I keep get error msg. when i try partial reload.

       

       

      sales:

       

       

      LOAD Subject,

       

       

           [Due Date] as DATE,

           [Item Name],

           Quantity,

           [List Price],

           [Item Comment],

           Discount,

           Description

      FROM

      [C:\Users\Paul Yeo\Dropbox\0_Q_Development\JEREMY\Sales_Order.csv]

      (txt, utf8, embedded labels, delimiter is ',', msq);

       

       

       

       

      I have