Expression

[bobbydave]

Calendar

Below is my calendar expression..

I am writing a query and

Dual(Year(Today()) & '/' & Week(Today()), WeekStart(Today())) AS Fiscal_Year_LastWeek 

from my calendar.qvd which gives me the result 2017/35

I want to show the previous week. How can I alter this. I've added -1 everywhere in the above expression.

I want to show the previous week 2017/34

[Anil_Babu_Samineni]

Perhaps this?

Dual(Year(Today()) & '/' & Week(Today())-1, WeekStart(Today())) AS Fiscal_Year_LastWeek

[sunny_talwar · Accepted solution]

May be this

Dual(Year(Today()-7) & '/' & Week(Today()-7), WeekStart(Today(), -1)) AS Fiscal_Year_LastWeek

[sunny_talwar]

Or this

Dual(Year(Today()-7) & '/' & Week(Today()-7), WeekStart(Today()-7)) AS Fiscal_Year_LastWeek