ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> Crystal Reports General Issues >> How to define date range
http://www.istechforum.com/YaBB.pl?num=1113851537

Message started by David Waldmann on 04/18/05 at 11:12:17

Title: How to define date range
Post by David Waldmann on 04/18/05 at 11:12:17

I am trying to create a selection criteria of the last full week before last week. Any suggestions?

Title: Re: How to define date range
Post by Tim Keating on 04/18/05 at 11:33:08

Not pretty but it seems to work:

dateadd("d",-7,(datetime(Minimum(LastFullWeek)))) <= {your date record} and
{your date record} < Minimum(LastFullWeek)

Title: Re: How to define date range
Post by David Waldmann on 04/19/05 at 09:24:17

Perfect. Thanks! :)