AnsweredAssumed Answered

How can date be automatically entered when only one field is modified?

Question asked by reink-dawg on Dec 20, 2015
Latest reply on Dec 22, 2015 by reink-dawg

I have records that contain a Starting Quantity field, a Current Quantity field, a Quantity Sold field which is a simple calculation field and a Date Sold field.  I would like the Date Sold field to automatically show the current date whenever the Quantity Sold field is increased (or the Current Quantity field is decreased.

 

Setting the Date Sold field to "auto-entry" Modified, sets the current date whenever any field is modified which I don't want.

 

Any suggestions?

Outcomes