Date Scripting

[akpofureenughwu]

Greetings evening,

Please I need assistance in creating the day function on this date script.

load*,

'Q'&ceil(month(date#([Month],'MMM'))/3) as [Quarter],

Date(Date#(Month&'-'&Year, 'MMM-YYYY'), 'MMM-YYYY') as Date;

load

.....................................................

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

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

     right([Fiscal year/period - Fiscal year/period Level 01 (Text)],4) as Year,

     Capitalize(    If(Index('SP1,SP2,SP3,SP4,Per,', left([Fiscal year/period - Fiscal year/period Level 01 (Text)],3)),'DEC', left([Fiscal year/period - Fiscal year/period Level 01 (Text)],3))) As [Month];

With the above script, I can only generate year, quarter, month, date

I need the day function.

Thank you for viewing this

Regards

[its_anandrjs]

Please provide some sample data to look over.

Regards

Anand

[johnw]

The day of the month? Maybe this?

day(date#(Month&Year,'MMMYYYY')) as [Day of Month]

[MarcoWedel · Accepted solution]

maybe like this:

load *,

      Day(Date) as Day;

load*,

'Q'&ceil(month(date#([Month],'MMM'))/3) as [Quarter],

Date(Date#(Month&'-'&Year, 'MMM-YYYY'), 'MMM-YYYY') as Date;

load

.....................................................

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

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

    right([Fiscal year/period - Fiscal year/period Level 01 (Text)],4) as Year,

    Capitalize(    If(Index('SP1,SP2,SP3,SP4,Per,', left([Fiscal year/period - Fiscal year/period Level 01 (Text)],3)),'DEC', left([Fiscal year/period - Fiscal year/period Level 01 (Text)],3))) As [Month];

hope this helps

regards

Marco