Print Page | Close Window

Crystal report formula for wednesday to wednesday

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Writing Code
Forum Discription: .NET 2003 programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=11505
Printed Date: 02 May 2024 at 3:41pm


Topic: Crystal report formula for wednesday to wednesday
Posted By: aneel
Subject: Crystal report formula for wednesday to wednesday
Date Posted: 25 Oct 2010 at 3:04am

I do have one requirement like: report should fetch data from (last Wednesday 16:00:00 to  following Wednesday 15:59:59).

 

How can I write formula for this ??



-------------
Anee Chandanam


Replies:
Posted By: lockwelle
Date Posted: 30 Nov 2010 at 3:28am
I would look up WeekDay or DayOfWeek in the Crystal Help to get a start.  You would have to perform logic in your report to determine the date range and then you could update an array and limit the records to those that have dates in the range (or you could just use and if statement instead of the array).
 
Or you could use a stored proc as a datasource and do the filtering there.  I don't know off-hand, but I am sure that there is a WeekDay function there as well (or something similar)
I realize that you have probably found a solution by now.


Print Page | Close Window