Change the value of a field when a date has expired

[paul_roberts]

Hi All,

I'm looking at finding a way to update a field based on a date field's expiry.   It seems this may require some Scripting.

I'd like to be able to populate a read only field (u_change_window_exceeded_) to display the value of 'Yes' based on the expiry of a date field (end_date).

I'd also like to further automate a calculation to display the amount of time past the expiry (u_by_how_long_) if possible?

Thanks

Paul

[paul_roberts]

Thanks Christine, this is an idea that i'd not thought of.   I'll have a look and see if it can be applied here.