Date

[akpofureenughwu]

I want to create a month, day, quarter year  date format from a field but it's not responding well. Please find the attached files for clarity.

[sunny_talwar]

May be this:

LOAD *,

          Day&' '&Month as _Month;

LOAD *,

          Month(Date) as Month,

          'Week '&Week(Date) as Week,

          Year(Date) as Year,

          'Q' & Ceil(Month(Date)/3) as Quarter,

          'Day '&Day(Date) as Day,

          Day(Date) as nDay;

LOAD [Company code - Company code Level 01 (Key)],

     [Company code - Company code Level 01 (Text)],

     [Sales Organization - Sales Organization Level 01 (Key)],

     [Sales Organization - Sales Organization Level 01 (Text)],

     [Division - Division Level 01 (Key)],

     [Division - Division Level 01 (Text)],

     [Distribution Channel - Distribution Channel Level 01 (Key)],

     [Distribution Channel - Distribution Channel Level 01 (Text)],

     [Reason for order - Reason for order Level 01 (Key)],

     [Reason for order - Reason for order Level 01 (Text)],

     [Laycan End Date - Laycan End Date Level 01 (Key)],

   Date(Date#( [Laycan End Date - Laycan End Date Level 01 (Text)], 'DD.MM.YYYY'), 'DD/MM/YYYY') as [Date],

    [Laycan Start Date - Laycan Start Date Level 01 (Key)],

     [Laycan Start Date - Laycan Start Date Level 01 (Text)],

     [VESSEL NAME - VESSEL NAME Level 01 (Key)],

     [VESSEL NAME - VESSEL NAME Level 01 (Text)],

     [Fiscal year - Fiscal year Level 01 (Key)],

     [Fiscal year - Fiscal year Level 01 (Text)],

     [Sales unit - Sales unit Level 01 (Key)],

     [Sales unit - Sales unit Level 01 (Text)]

FROM

(qvd);