Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to find weekago function example 2012,2013
listbox should be 1-104th
Please check this
thanks PM
i got it with that reference link .
weekago:
,53*(Year($(vMaxDate))-Year ([DATE])) + week($(vMaxDate) ) - week( [DATE]) as weekAgo.
Please close this thread with marking correct answer it will helpful to another one.
😧
load
date(makedate(2015) + rowno() -1) as d
AutoGenerate 365*3;
let vMaxDate = Today();
left join (D)
load
d,
DIV('$(vMaxDate)' - d, 7) as WeekAgo
Resident D;