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?
repcoAsked:
Who is Participating?
 
peter57rConnect With a Mentor Commented:
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
0
 
peter57rCommented:
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
0
 
ThomasBallardITCommented:
You could just make a parameter by the date field and do a range.
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
repcoAuthor 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!
0
 
repcoAuthor 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
0
 
repcoAuthor 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!
0
 
repcoAuthor Commented:
yeah i was selecting the wrong group thats why. all working great now thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.