Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this
Dual(Year(Today()-7) & '/' & Week(Today()-7), WeekStart(Today(), -1)) AS Fiscal_Year_LastWeek
Perhaps this?
Dual(Year(Today()) & '/' & Week(Today())-1, WeekStart(Today())) AS Fiscal_Year_LastWeek
May be this
Dual(Year(Today()-7) & '/' & Week(Today()-7), WeekStart(Today(), -1)) AS Fiscal_Year_LastWeek
Or this
Dual(Year(Today()-7) & '/' & Week(Today()-7), WeekStart(Today()-7)) AS Fiscal_Year_LastWeek