Last 6 weeks function?

[shannonlp]

Hi,

I have a report that displays 3 columns of data in the details section. I’m basing a line chart of this data. I need to restrict the data so that it displays only the last 6 weeks from the current date. I’ve looked at the Last4WeeksToSun function thinking I could use it but I’m not sure if it will work.

Advances Change Week to Week
9/10/10 78,762,764,312.00
9/17/10 78,554,364,889.00 -208,399,423.00
9/24/10 79,140,287,891.00 585,923,002.00
10/1/10 79,143,019,604.00 2,731,713.00
10/8/10 79,502,788,295.00 359,768,691.00
10/15/10 78,443,623,057.00 -1,059,165,238.00
10/22/10 77,757,518,326.00 -686,104,731.00
11/5/10 78,161,298,349.00 403,780,023.00

Any advice would be greatly appreciated.

Thanks,
Shannon

 

[IanWaterman]

there is no function but you can use dateadd

{Yourdatefield} >= datadd("ww", -6, currentdate)

Ian

 

[lbass]

Typo. Should be: dateadd()

-LB

 

[shannonlp]

Perfect! Thanks to you both.