ui action

[rognomolta]

The problem requires creating a UI Action in ServiceNow that automatically updates the status of a record in the vpm_activity_instance table based on changes made to the Achieved Date or Expiration Date fields. The status should be updated according to the following rules:

If both Achieved Date and Expiration Date are filled in and the current date falls between them, set the status to "Achieved".
If both Achieved Date and Expiration Date are filled in and the current date is after the Expiration Date, set the status to "Expired".

so i tried with ui action and business rule but not working

 Please provide  best approach

add  a screenshot of the form below

@Ankur Bawiskar , @Dr Atul G- LNG , @Sandeep Rajput ,@Sandeep Dutta 

[Dr Atul G- LNG]

Sorry mate, not in my scope. 

[Ankur Bawiskar]

@rognomolta 

so what did you try so far?

please share the script. it should be an easy one with GlideDateTime comparison