Welcome, Guest. Please Login.
05/10/24 at 02:42:30
News:
Home Help Search Login


ISTech Support Forum › Crystal Reports, ODBC & Access › Crystal Reports General Issues ‹ Previous topic | Next topic ›
Pages: 1
Send Topic Print
How to define date range (Read 779 times)
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1924
Gender: male
How to define date range
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?
Back to top
 
 
David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
Tim Keating
Senior Member
****


DBA CLASSIC WIN 2000
C/S

Posts: 298
Re: How to define date range
Reply #1 - 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)
Back to top
 
 
Tim Keating
Motor Guard Corporation
Email WWW   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1924
Gender: male
Re: How to define date range
Reply #2 - 04/19/05 at 09:24:17  
Perfect. Thanks!  Smiley
Back to top
 
 
David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
Pages: 1
Send Topic Print
ISTech Support Forum › Crystal Reports, ODBC & Access › Crystal Reports General Issues ‹ Previous topic | Next topic ›

ISTech Support Forum » Powered by YaBB 2.1!
YaBB © 2000-2005. All Rights Reserved.

Valid XHTML Valid CSS Powered by Perl Source Forge