AnsweredAssumed Answered

Date stamp or field empty, depending on another fields contents?

Question asked by Flyfisher2611 on Oct 27, 2018
Latest reply on Oct 27, 2018 by Flyfisher2611

Hi, I could do with a little help please!

 

I'm struggling with something that, in my own mind, I think should be easy!

I have a field that is populated with a value list with just two values

'Ordered'

&

'Not Yet Ordered'

 

I also have a "date ordered" field

 

I wish to have the date field show the date the above field is changed to 'Ordered' I did this through auto enter on modification.

 

My problem is that I want to delete the date and leave the field empty if the field is changed to 'Not Yet Ordered' this is the bit I'm struggling with!

 

Any help would be gratefully appreciated

 

Kind regards

Alan

Outcomes