Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DATE PARAMETERS
- Thread starter saradaga
- Start date
IanWaterman
Programmer
Generally Date Params default to current date.
Thus you can have one param and two formula.
@Startdate
date(year(dateadd("m", -1, {?dateparam}), month(dateadd("m", -1, {?dateparam}), 01)
@EndDate
date(year({?dateparam}), month({?dateparam}), 01)-1
Of course for these formula you do not really need a param and can just use the Crystal function currentdate instead.
Use these formula in select and display on report. Crystal will calculate and pass to database.
Ian
Thus you can have one param and two formula.
@Startdate
date(year(dateadd("m", -1, {?dateparam}), month(dateadd("m", -1, {?dateparam}), 01)
@EndDate
date(year({?dateparam}), month({?dateparam}), 01)-1
Of course for these formula you do not really need a param and can just use the Crystal function currentdate instead.
Use these formula in select and display on report. Crystal will calculate and pass to database.
Ian
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question