Fixed Parameter Values 2

[Dominican1979]

Hello Everyone,

I have a report that takes 3 parameter values. Customer Number, Start Date and End Date. I currently have the users enter all this information. However, I want to have the users only enter the customer number have the start date fixed to be 01/01/2007 and the end date to be the current date. I think I figured out the end date part. This is what my selection formula looks like.

{USASalesRepCustListMS.CustNo} > 0 and
{@ConvertInvoDate} in {?StartDate} to CurrentDate and
{USASalesRepCustListMS.CustNo} = {?CustNo}

I can't figure out how to make the start date just a fixed date. Thank you very much for your help!

 

[Turkbear]

Hi,
One way:

{@ConvertInvoDate} in Date(01,01,2007) to CurrentDate



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[raja2008]

If your start and end dates are fixed why do you need the parameters for the date.

{@ConvertInvoDate} >=date(2007,01,01) and
{@ConvertInvoDate}<=currentdate

 

[Dominican1979]

Thanks a lot for your help. I probably explained it the wrong way. I had parameter values and wanted to change that to fixed values like you guys explained above.