date range to current date at specific time syntax question
I have a cr8 report running that prompts the user to enter a date
range. Regardless of the dates entered, I want to restrict data to
include data only up to the current date as of 3 a.m.
How can I accomplish this in Crystal?
>>
Set up a formula called End_Date that looks like thie
If Maximum({?DateRange}) > CurrentDate then CurrentDate else
Maximum({?DateRange})
Then in your select formula you would say:
I think I would actually set up another formula to stirp off the Begin Date as
well just to make it look neater (and only do the calculation once), but it
should work the way I explained it.
Charliy
