Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
YeartoDate(TempDate)*-1 as CurYTDFlag,
Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as WeekYear,
how it works pls?
YeartoDate(TempDate)*-1 as CurYTDFlag,
yeartodate return true if date fall in the year of the date so if it is true (that is -1) multiply by -1 and have 1, if it is false (that is 0) you have 0
The same as previous but for previous year
returns true if date falls inside the year computed from Monthstart($(varMaxDate)),-1) that is the starting date of the month before the one indicated by the variable
Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as WeekYear,
this returns a string with the week of the date of weekstart and its year
Hi,
YeartoDate(TempDate)*-1 as CurYTDFlag,
This is calculates the values as true and false depends on the result YeartoDate returns the true and false according to the result it gives output as 1 and 0
YeartoDate(TempDate,-1)*-1 as LastYTDFlag,
This calculates the previous year values as 1 and 0
inyear(TempDate, Monthstart($(varMaxDate)),-1) as RC12,
Returns true if date lies inside the year containing Monthstart($(varMaxDate)) and according to that multiples.
Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as WeekYear,
And this returns the Week of the weekstart(TempDate)
Regards
Anand