Date Parameter...

[stormtrooper]

I'm pretty new to Crystal Reports but have been working with Access for quite some time. I need to grab data from a date field and I need it from the current date and back 3 months. (ie. info from today back to Jan.18)

I'm thinking '{field} in currentdate to currentdate-something'

Please advise.
Thanks,
Stormtrooper

 

[kenhamady]

Adding or subtracting 3 months to a date can be a problem depending on your version. In V8 use the DateAdd() function to add a -3 months. If you have V7 you can download the Date DLL from Crystal's website to use the DateAdd(). If you can't use this dll for some reason, my FAQ on common formulas shows a formula that allows you to add (or subtract) a number of months from a date. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)