Report on last full 2 weeks in a period

[goldyr]

I want to create a formula that gives me all records from the last period of 2 weeks. (The year has 26 periods starting with week 1)
I have found the formula LastFullWeek but how can I get 2 weeks in right period? Period 1: w1 + w2 Period 2: w3 + w4 and so on...
I also whant the report to present the periods last date (ends on saturday).

 

[synapsevampire]

Just leverage the lastfullweek using something like:

{Orders.Order Date} >= minimum(lastfullweek)- 7
and
{Orders.Order Date} <= maximum(lastfullweek)

-k

 

[goldyr]

Thanks, but in what format is the date in?
My date comes as numeric 20030526 from the database and I have converted it in the report but it doesn´t work in the formula.

 

[synapsevampire]

No worries, I did it based on a real date field.

Try converting the dates, as in:

{table.field} > =val(totext(minimum(lastfullweek),&quot;yyyyMMdd&quot)
and
{table.field} <= val(totext(maximum(lastfullweek),&quot;yyyyMMdd&quot)

This should generate the proper SQL to pass to the database too.

To display the highest date, right click the date field and select insert summary->Maximum

Hope this resolves.

-k