AnsweredAssumed Answered

How Can I Change A Field for only Future Records (not affecting current records)?

Question asked by enyko on Dec 17, 2013
Latest reply on Dec 17, 2013 by philmodjunk

Title

How Can I Change A Field for only Future Records (not affecting current records)?

Post

     Sorry if this has been answered somewhere but I tried searching and couldn't find it.

     I have some price changes on our services and I'm wondering how to change the price on one product moving forward so it doesn't affect our current / previous clients. For example, our "Product A" has always been $500, we are now changing it to $650 moving forward for new clients. But when I change the amount to $650, it changes all our previous clients amount too which in turns shows that they have a remaining balance of $150 now. How do I just change it moving forward without affecting current & previous clients?

     We are using a calculation field that says; If ( Product A = "Yes" ; 500 ; 0 )

     Thank you!

Outcomes