I've been working on this for several weeks.If I set it up with a parameter to choose "Today's date" it won't work.It worked 1 time but will not work on a refresh with new parameters.I got it to work somewhat by using a summary named "Invoice Date" summarizing the cust_name field, Max summary.Then I evaluate the invc_dat field "on change of field".Reset never.I placed the summary and suppressed it so it won't print into the details section as well as placing the invc.dat and suppressing it too.That way neither will print as I don't want them to, it's a mailing label.I then went to the Select Expert and chose the invc_dat field and"is greater than or equal to" because it won't work at all with anything else,I just get a blank report.The formula is {JR80.INVC_RDAT} >= "34813".At present it's greater than or equal to "34813" but now here is where the problem comes in. I have to manually change the greater than or equal to to the next number every time or it will print that day as well as the new day.This is for the Accounts Payable department and the Crystal reader they have access to will not ,for some reason, refresh the report or allow them to make the necessary change so I have to do it for them.Then when they open it they are able to print it with no problems.

Sorry, I have a tendency to do that sometimes.

I want to pull records for today, though before would be a plus however the report will only work (as written) set for today or later.Also I have to summarize the Name field.Anything else and all I get is a blank report. The {JR80.INVC_RDAT} is the only date field available in any of the invoice tables so it's all I have to work with.I know it's something simple I'm overlooking but I just can't see what it is.

It probably does because when I change the date in select expert to refresh the information it is a number not a date.Today's is 34815.

Thanks for the help.

When I change the formula from {JR80.INVC_RDAT} = "34815"
to {JR80.INVC_RDAT} >= datediff('d',date(1916,1,1),currentdate) it says I need a string after the >=

Thank you sir.That did the trick.