Hi :

I am not sure if I am on the correct forum or not. I am trying to use progress and using reporting services to generate a report. I want to select a list of order based on order date.

SELECT PUB.co."order-date", PUB.co."est-num", PUB.co."cust-num",
FROM PUB."ux-co", PUB.co
WHERE OrderDate between @StartDate and @EndDate

I am much more familiar with sql server syntax than progress syntax.
If this is incorrect please let me know.

When I tried that it asked me to use to_date(). But when I tried using to_date(). It complains. I am using the dataset in ssrs 2008 r2 reporting service to retrieve order information back from progress. I am not sure if this is possible.

We are currently using progress 6.0 Merant driver 3.60.