Filtering Dates

[Thoth]

I am creating a report to display parts that have a QOH greater than 0 and that have not moved in over a year. Easy enough so far. The problem I am having is filtering the transaction dates for the parts.

What I am trying to do is display the most recent record for the part only if the transaction date is more than a year old. This is where I got stuck. Writing formulas is not my strong point, so I do not know where to begin on evaluating these dates.

Any help would be most appreciated.


Thanks in advance,

Dean

 

[synapsevampire]

Add to the record selection something like:

{transaction date} < dateadd(&quot;yy&quot;,-1,currentdate)

Group by the part and order by transaction date.

Place the fields in the group footer of the part.

You'll get the most recent row.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com