Getting last4weeks data

[reacha]

I have a report which is grouped by username first

and after that grouped by auditstamp for each week.

now what i need to write in the record selection to get last4weeks data

Please help me out!!



Thanks,
reacha

 

[Turkbear]

Hi,
Is the auditstamp field a DATE field?

If so then a selection formula something like

auditstamp In DateAdd(w,-4,auditstamp) to CurrentDate

should get that range



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[reacha]

yes it is a datefield...

but this didn't worked and i tried something like Last4WeeksToSun


Thanks,
reacha

 

[VKZIMM]

Try
Auditstamp in DateAdd("ww", -4, currentdate) to currentdate

Four weeks prior from today's date.

 

[Turkbear]

Hi,
Good catch VKZIMM!

I should have looked at my logic more closely.







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[reacha]

i am getting different values if i use

Auditstamp = Last4WeeksToSun
and
Auditstamp in DateAdd("ww", -4, currentdate) to currentdate

what is the difference in these two and some times i am getting more than 4 weeks if i use any one of those.
I need to get exactly Last 4 weeks

Thanks,
reacha

 

[Turkbear]

Hi,
Last4WeekstoSun can be different from 4 weeks before CurrentDate if CurrentDate is not Sunday.

Try:

AuditStamp >= (CurrentDate - 28 )





To Paraphrase:"The Help you get is proportional to the Help you give.."