Date

akpofureenughwu — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Date

sunny_talwar — Thu, 16 Jun 2016 15:42:37 GMT

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