Date Range Parameter 1

[rmiller11]

I am not sure how to do a date range parameter. I am new to parameters.

I have a field called WoShipLog.ShipDate and I want the report to ask the beginning >= and ending <= Dates.

 

[synapsevampire]

Select Insert-Field Object->Right Click parameters and select New.

Change the type to Date and select Range Values.

Now select Report->Edit Selection Formula->Record and place:

{WoShipLog.ShipDate} = {?MyDateRangeParm}

Replacing {?MyDateRangeParm} with your parameter name.

-k

 

[rmiller11]

I must be missing something. It askes the date but when the report prints, it does not give me the date specified.

Parameter -> Ship Date:
ValueType: Date Time, Options: Range value, Options: Range Limited Field

Formula Field: ShipDT
{WoShipDateMult.PackSlipDate} = {?Ship Date}

 

[synapsevampire]

Check the previous post:

Now select Report->Edit Selection Formula->Record and place:

{WoShipLog.ShipDate} = {?MyDateRangeParm}

What does it does not give me the date specified mean, it gives you records but not the date specified?

Copy and paste the record selection formula you used, and also the SQL (Database->Show SQL Query)

-k

 

[rmiller11]

It is working...

Thank you for your help.