how to find weekago function?

[krishna789]

how to find weekago function example 2012,2013

listbox should be 1-104th

[prma7799]

Please check this

Create Indicator for 4, 8, and 13 weeks ago in Calendar

[krishna789]

thanks PM

i got it with that reference link .

weekago:

,53*(Year($(vMaxDate))-Year ([DATE])) + week($(vMaxDate) ) - week( [DATE]) as weekAgo.

[prma7799]

Please close this thread with marking correct answer it will helpful to another one.

[maxgro]

😧

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;