Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to creat YTD QTD MTD WTD Flag's in script level
and i want create rolling 6 months date's also in script level
can any one help me
thanks & regards
hareesh
I would recommend you to check out the in... section of the date and time section.
Any another sample script show me if possible
I generated the objects above with the output of the script below.
Calendar: LOAD %date, DayName(%date) as Date, Week(%date) as Week, WeekName(%date) as YearWeek, Month(%date) as Month, MonthName(%date) as YearMonth, QuarterName(%date) as YearQuarter, Year(%date) as Year, InYearToDate(%date,today(),0) as _inYTD, InMonthToDate(%date,today(),0) as _inMTD, InQuarterToDate(%date,today(),0) as _inQTD, InWeekToDate(%date,today(),0) as _inWTD ; LOAD (Today() - IterNo()+1) as %date autogenerate 1 WHILE IterNo() <= 365 //365 day calendar ;