Hello-

I have a report that I need to pull in a recv date field. This field can only be in the date range of a month end field. How can I tell this field to do this?

For example:

recv date          end of month
1-4-16               1-31-16
1-15-16               1-31-16
2-18-16               1-31-16
7-19-16               1-31-16

So I only want the first 2 dates. The others should group into their proper month. I am grouping on the end of month field. I hope this makes sense.

Thanks in advance!

Thank you for your reply. Let me try to clarify.

I have a field that is a batch date and will usually be the last day of the month. I am grouping on this field. The next field I have is a recv date. Currently my report is pulling everything that has been recvd for a particular po. So if something was recvd in oct 2015 (or any other month) it is showing. Ideally I only want to show the lines that were recvd during a particular batch date. So if my batch date is Jan 2016, I only want to show the po lines that were recvd in Jan 2016 not any other month. There could be multiple lines on a po or even multiple recvgs to a line. Each recpt does have it's own recv date.

I hope this makes more sense. Again thanks for the help!!

that works sort of. I put that formula into the section expert to suppress that info but instead it is giving me all the "false" info. Is there something I should do to make it only show me the "true" info?

Wonderful! tyvm for your help! much appreciated as always!