Date formating in Crystal reports

[aarong2]

I'm not at all familiar with Crystal Report Syntax. I currently have a report that pulls data using the following example.
({@date}>Date(2002,11,6))and({@date}<Date(2002,11,8))

This works fine if the user wants to specify the date range everytime. However, I would like to schedule this report as a job and to use the current date. How do I change this report parameter to use today's date? How about the past seven days?

Aaron
aarong@connexusenergy.com

 

[mbarron]

Create you date parameter (StartDate's a good name for it.)

(@date) in ({?StartDate}) to CurrentDate


Mike

Before: After

 

[dgillz]

{@date} in CurrentDate to Dateadd(&quot;d&quot;,-7,CurrentDate)

give you the last 7 days. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[aarong2]

Thanks for the help that works!!

Aaron