• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 390
  • Last Modified:

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?
0
repco
Asked:
repco
  • 4
  • 2
1 Solution
 
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
 
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
Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now