Relative calendar field: WeeksAgo

[#1]

Hi, i'm very new to Qliview and am trying to set up some relative calendar dates in my Master Calendar. I found these statements on one of the design blogs and they're very useful.

Today() - Date as DaysAgo,

12*(Year(Today())-Year(Date)) + Month(Today()) - Month(Date) as MonthsAgo,

However, I really need one for WeeksAgo as well

My best guess was

52*(Week(Today())-Week(TempDate)) + Week(Today()) - Week(TempDate) as WeeksAgo

but this doesn't seem to work. What am I doing wrong?

[#2 · Accepted solution]

I found the answer somewhere

(WeekStart(Today()) - WeekStart(TempDate))/7 as WeeksAgo