Date Formula 1

[Crystalamateur]

Hi there

I print a report that shows the total monies received between in a time frame e.g. 1 January until 31 March.

My report includes all donations received between the period stated, however, I need to show the date of the last payment received. If someone makes monthly payments of £20.00 on 15JAN, 15FEB & 15MAR I should show a a total received of £60.00 but the last payment made on 15 March.

I have a formula which is:-
if {Payments.Paydate} <= {?end date}
then {Payments.Paydate}

But this formula then shows the correct amount but the date of the first payment.

Any ideas, help please.

many thanks
Peter

 

[IanWaterman]

If you can sort the details by payment date in ascending order. If you then just place the date payment date filed in your group footer showing total received, it will show the correct last date.

If you are using report header to show summary, just change sort order to descending.

Ian

 

[lbass]

You could also right click on your formula (assuming it is placed in the detail section) and insert a maximum on your formula.

-LB