can any body explain about these script
- YeartoDate(TempDate)*-1 as CurYTDFlag,
- YeartoDate(TempDate,-1)*-1 as LastYTDFlag,
- inyear(TempDate, Monthstart($(varMaxDate)),-1) as RC12,
- date(monthstart(TempDate), 'MMM-YYYY') as MonthYear,
- ApplyMap('QuartersMap', month(TempDate), Null()) as Quarter,
- Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as WeekYear,
- WeekDay(TempDate) as WeekDay
How it will work
explain above script