How to find a record using a value from another field in the same record

Discussion created by anubeazh on Jul 5, 2017
Latest reply on Jul 5, 2017 by anubeazh

there are some products that have special incentive rate for a range of days. A product must be sold during that time period in order for a Sale to get extra incentive.


From the attachments, you can see the SaleDate of products and ::DateStart and ::DateEnd of the incentive period. I need to insert SaleDate in to those ::DateStart and ::DateEnd fields. Something like " > SaleDate" and " > SaleDate".


The question is how can i do that?


Thank you for the help.