Link to home
Start Free TrialLog in
Avatar of kelsanit
kelsanit

asked on

Crystal Week to date

need help with date range in crystal.

Want to run report value for Weektodate but do currentdate-1 as start point.

example:
today is Thursday when report is ran
want to show values for Sunday-Wednesday
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of kelsanit
kelsanit

ASKER

yes, I have used that function but need to know how to get the following:

If today is Thurday I need the data to return Sunday-Wednesday  not Sunday - Thursday
The second formula I provided should give you that.


(YourDateField} >= Minimum(WeekToDateFromSunday)
 AND
 (YourDateField} < Maximum(WeekToDateFromSunday)

mlmcc