Link to home
Start Free TrialLog in
Avatar of repco
repco

asked on

Finding Minimum Date Value

Greetings,

I'm trying to create a report where it shows all the new orders greater than a date that i specified.

So, the report should look through all the orders and if the minimum order date is greater than or equal to the date i specified, then list those orders.

The way i have it is in the record select,

minimum(orders.startdate) = {?Start Date}

but i get an error msg saying "This formula cannot be used because it must be evaluated later.

any other suggestions?
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Hi repco,

Don't understand your use of Minimum here.

Don't you just want all orders whose date is on or after your parameter date?

{Orders.Startdate}>={?Start Date}


Pete
You could just make a parameter by the date field and do a range.
Avatar of repco
repco

ASKER

No, what i want to do is find out all new accounts that are greater than or equal to the parameter date.

so it should look through ALL the records and if the MINIMUM date for that customer is greater than the parameter date, then display.

thanks!
ASKER CERTIFIED SOLUTION
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of repco

ASKER

ok let me get this straight b/c so far its not working for me.

i will grab the datefield and summarize it to show minimum. then i select that field (min of stardate) and do a select expert which should be greater than or equal to the parameter?

if thats the case, it doesn't work. i still see all records, BUT i do see that the min does show the minimum date (1/3/99) for each customer
Avatar of repco

ASKER

wait nevermind, i had to do it twice. for some reason i had to select expert on the min field twice. thats weird b/c now i see two select experts for the min field. oh well as long as it works! thanks!
Avatar of repco

ASKER

yeah i was selecting the wrong group thats why. all working great now thanks!