function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
ETadminETadmin 

Return more recent date

I'm tracking collection of installment payments inside a custom object. I want to create a formula field "most recent payment" to calculate collections in a report - what equation can I use so that the result is whichever of payment1, payment2, payment3 that is the most recent date?
KaushikKaushik

Hi

Are all the payments in the same instance?

or do the payments belong to different records?

 

Thanks

Kaushik
ETadminETadmin
They all belong to the same record - they are installments (i.e. someone buys a 12 Month product and pays in monthly installments I want to see what was the most recent installment they paid).
KaushikKaushik

Hi

Try to use the revenue scheduling available in products.As reports can access revenue scheduling,you can report the next date,next amount and so on.

Thanks