Finding Minimum Date Value

repco
repco used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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.

Author

Commented:
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!
Become a Certified Penetration Testing Engineer

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

Build the report to show all records, group by customer,  and insert a summary on the datefield to get the minimum for each customer.
Use the select expert on the group min field to select just those groups wher the value is greater or equal to your parameter value.

Pete

Author

Commented:
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

Author

Commented:
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!

Author

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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial