Writing Code
 Crystal Reports Forum : Crystal Reports .NET 2003 : Writing Code
Message Icon Topic: Crystal report formula for wednesday to wednesday Post Reply Post New Topic
Author Message
aneel
Newbie
Newbie


Joined: 22 Jun 2009
Location: India
Online Status: Offline
Posts: 6
Quote aneel Replybullet Topic: Crystal report formula for wednesday to wednesday
    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
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet 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.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.