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?
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?
You could just make a parameter by the date field and do a range.
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!
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
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!
ASKER
yeah i was selecting the wrong group thats why. all working great now thanks!
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}>={?Star
Pete