Month

[ejriri]

Hi. How can I program the following data,

Our Monthly cut off is every 25th of the month. For example 

Data from January  26 - February 25 - will be considered for the month of February

February 26 - March 25 will be considered for the month of March. 

How can I program it at data load editor? 

[justISO]

Hi, near your 'master calendar', you can add additional field for this 'recalculated month' (where [Date] your 'normal' date field):

if(day([Date])>25, MonthsName(1,[Date],1), MonthsName(1,[Date],0))

[vinieme12]

As below

temp:
Load Date
,Month(IF(Day(Date)>=26,AddMonths(Date,1),Date)) as ModifiedMonth
,Month(Date) as CalendarMonth
;
Load
date(date#('2021-01-01','YYYY-MM-DD') +iterno()-1) as Date
AutoGenerate 1
While date#('2021-01-01','YYYY-MM-DD') +iterno()-1 <= date#('2023-03-01','YYYY-MM-DD');

Exit Script