Select Date Field via Parameters 1

[teamssc]

I have a date field {ConHist.ONDATE} and I want to select records from the {ConHist.ONDATE} between the parameters {?start_date} and {?end_date}

I can't seem to come up with a working solution. It seems that I have to either convert {ContHist.ONDATE} to a string or I have to convert {?start_date} and {?end_date} to a date.

 

[synapsevampire]

Yes, you should use date parameters when comparing to a date.

It gives the user a better interface, and prevents you from conerting them is the record selection formula.

Right click the parameters and select Edit, and change they type to Date.

-k

 

[teamssc]

DUH... For the life of me I wasn't see the Value Type. Just dumb on my part. Thanks!