Time

[mario-sarkis]

Dear aLL

i Have to variable

vYearstart=num(Daystart(YearStart(Date(max(PeriodDate)))))

vMaxDate=Max({1<Year=$::Year,Month=$::Month,Quarter=$::Quarter,MonthName=$::MonthName,Day=$::Day>} PeriodDate)

i am Seeing the YTD profit using

PeriodDate={">=$(vYearStart) <=$(vMaxDate)"}

I need to Seen the same Period of Time as per last year

help please,

[Gysbert_Wassenaar]

Maybe like this: PeriodDate={">=$(=addyears($(vYearStart),-1))<=$(=addyears($(vMaxDate),-1))"}

If not, please post a qvw document that demonstrates the problem.

[its_anandrjs]

You can try with Addmonths() also

PeriodDate={">=$(=Addmonths($(vYearStart),-12)) <=$(=Addmonths($(vMaxDate),-12))"}