Load dates in script

Hi,

here is one of the methods to do it:

SET v_STARTDATE = '01/01/2016';

SET v_ENDDATE = '01/12/2017';

TMP_DATE:

LOAD date(date#('$(v_STARTDATE)','DD/MM/YYYY')-1 + recno() ,'DD/MM/YYYY') as Date

AUTOGENERATE (date#('$(v_ENDDATE)','DD/MM/YYYY') - date#('$(v_STARTDATE)','DD/MM/YYYY')) + 1 ;

DATE_TABLE:

LOAD

*,

Month(Date)&Year(Date) as Month_year

RESIDENT TMP_DATE

where Date < AddMonths(today(),-1) and Date > AddMonths(today(),-11);

DROP TABLE TMP_DATE;

Hope it helps

YB

Table:

load

Date(AddMonths(MonthStart(today()), -iterno()), 'MMM YY') as Date

AutoGenerate 1

While IterNo() <= 11;