LastFullWeek operator problem

[MattRichardsUK]

Hi Guys, I need to get data for the FullWeek before the LastFullWeek (last but one full week if you like) is there a way of doing this or does anyone have a formula i could use.
I am using Crystal 8.5 on a Sybase Adaptive Server. Date is coming from a {Datetime} field.
thanks in Advance
Matt

 

[dgillz]

Try this:

{Datefield} In Dateadd("d",-7,Minimum(LastFullWeek)) to Dateadd("d",-7,Maximum(LastFullWeek)) Software Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com