date Range parameter in Crystal
Posted on 2006-06-08
Hi All, need help quick.
First I have a Date Range Parameter in my crystal report. I use this parameter to determine if the Hours fall with in the date range. Now I need to add a column that is Previous month. Since this field is not actually a DATE field I can not use it in the DATEADD function. So I stripped the field to a text field to give me the StartDate in a field Called StartDate. This is a Formula field and Not defined as a DATE field. So I can not use the StartDate in the DATEADD function to get the previous month.
So basically what I need is the the Previous month Range based on the parameter entered for the Date Range. The parameter entered is always a single month.
this is urgent please help