Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I want to display month start and end date according to campaign specific.
Here campaign starts from tuesday to sunday in a month, we wont take continuation of next month to current month date.but continuation of previous month is taken as current month start.
Example: If you take july calender, my month start should be: 27-06-2016 month end : 31-07-2016
If you take june calender, my month start should be : 30-05-2016 month end : 26-06-2016
Note: set your calender to start from monday.
How could i do this please help me on this.
Try tweaking the following script to fit your requirement:
chk dis
LET varMinDate = Num(Peek('OrderDate', 0, 'Orders'));
LET varMaxDate = Num(Peek('OrderDate', -1, 'Orders'));
LET vToday = Num(today());
//*************** Temporary Calendar ***************
TempCalendar:
LOAD
$(varMinDate)+IterNo()-1 AS Num,
Date($(varMinDate)+IterNo()-1) AS TempDate
AUTOGENERATE 1 WHILE $(varMinDate)+IterNo()-1<= $(varMaxDate);
//*************** Master Calendar ***************
MasterCalendar:
LOAD TempDate AS OrderDate,
week(TempDate) AS Week,
year(TempDate) AS Year,
month(TempDate) AS Month,
day(TempDate) AS Day,
weekday(TempDate) AS WeekDay,
applymap('Quarters_Map', num(month(TempDate)), null()) AS Quarter,
date(monthstart(TempDate), 'MMM-YYYY') AS MonthYear,
week(TempDate)&'-'&Year(TempDate) AS WeekYear,
Year2Date(TempDate, 0, 1, $(vToday))*-1 AS CurYTDFlag,
Year2Date(TempDate,-1, 1, $(vToday))*-1 AS LastYTDFlag
RESIDENT TempCalendar
ORDER BY TempDate Asc;