help

[NavinReddy]

Hi community,

i have date

1.how can i get previous five weeks ,

2.this month total weeks,

3.starting year to till date months should disply

all three different expressions

some one help me

thanks in advance

rohith

[#2]

1.how can i get previous five weeks ,==Date(WeekStart(Today())-35)

2.this month total weeks,===Floor(day(MonthEnd(today()))/7)

3.starting year to till date months should disply===if(Datefield>=YearStart(today()) and Datefield<=YearStart(today()), Datefield )

[NavinReddy]

hi kabilan,

thank you for your reply,

i will try this examples

Thanks,

rohith

[#4]

rolling 5 week

sum({<Date={">=$(=Date(weekstart(today())-35)<=$(=date(weekend(today())-35))"}, year=,month=,week=>}sales)