Have a date field on a form which I need to dynamically update based on the changing of a status field. The status field will start with a Pending status. The date field would be blank to start. Anytime going forward if the status field is changed as it goes thru the process, the date field would be updated with that days date. Essentially this field would be the last date the status was changed.
Any help is appreciated.