How do I update a date field using a business rule?

[Ryan157]

This is related to another post where I was asking how to create a report that will only show the last status report. The advise that I got from one expert user is to create a last_status_report field in the PM table then create a business rule that when "something" change then update the date to the status date. 

I'm hoping someone can guide me thru this process. I can't seem to figure out where my Business Rule is going wrong. 

1. Filter Conditions: When Status Date changes 

2. The field (in the project table) should get updated with the same date as the Status Date (as_on) field. 

Is there an easier way to do this to make it work? 

The last status date field is in the Project Table. I'm hoping when a new Status Report gets created the Business Rules fires off and updates the Last Status date field to be the same as the Status Date. 

[SanjivMeher]

In when to run, check the 'Update' checkbox instead of 'Insert' and in the Actions tab, use Set Value Project.Last Status Same As Status Date.

If that doesnt work, you may need to write a script by clicking Advanced checkbox and doing a GlideRecord record on Project table and update the Last Status

[Ryan157]

@sanjiv unfortunately that doesn’t work too. How do I write a glide record?

[Ryan157]

Hi @Sanjiv - this is what I created and it doesn't seem like to work 😞 

(function executeRule(current, previous /*null when async*/) {

u_last_status = GlideDate();

})(current, previous);

[SanjivMeher]

Try if below works.

var p = new GlideRecord('pm_project');

p.get(current.getValue('project'));

p.u_last_status = current.as_on;

p.update();