Setting up a date range parameter and displaying it in the report

In a recent report, I needed to return data based on a date range selected.  That’s easy enought to put in… you just create a new Parameter field, set the type to “Date” and make sure the “Allow range vales” option i set to true.  With the parameter field created, you need to add a record select formula that reads like this…

(TABLENAME.DATEFIELD) = {?DateRange Parameter)

…and all the records returned will be in that date range.

I also needed to display that range value in the report, which took a little digging to figure out.  All you need to do is to create a Formula field with the following code:


DateTimeVar date1;
DateTimeVar date2;

date1:=Minimum({?DateRange Parameter});
DateRange Parameter});

totext(Date(date1)) + ” and ” + totext(Date(date2))

 Then all you need to do is slap that formula field somewhere on the report, and it will display the date range selected in the parameter.


Thanks for reading!  I hope you found this helpful!



Jason Buss

Jason is a senior application developer with Customer FX.

1 Comment

  1. Thanks, this is just what I was looking for.


Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) news and product updates!

You have Successfully Subscribed!