I have created a field in the item table.That field will display the latest current price of the item.
I have updated the price for the item A as $10 from 01/01/19 to 31/12/19.the field will show $10 as the current price.
Suppose when i update the price of the item A for a certain period 01/10/19 to 30/11/19 as $15. It should display the current price as $15 for that period alone.After 30/11/19 it should display the previous price $10.
How to achieve this?