Opportunity age calculation code review please?

(0) Share

Report

Posted on by Community Member

Iprompt.GIF"/api/data/v9.1/msdyn_richtextfiles(16DDA1DF-A3BD-436E-B1F3-FC8E374069A7)/msdyn_imageblob/$value?size=full">I am using Microsoft Dynamics CRM 2011 on prem.

I am trying to write some code to find the age of a record from created on to sold.

We DO NOT use the out of the box CRM 'close as won' or 'close as lost' fields.....

We use an option set called 'Sales Stage' with multiple options, one of which is the value of 'Sold'...

I am trying to say, when sales stage value is set to sold, calculate the days between Created On Date and the Sold Date (custom date field), and then put the number in a field called 'Pipeline Age' (whole number field). Here's my code :

function ageofrecord_onchange() {

var createddate = Xrm.Page.getAttribute("createdon").getValue();
var solddate = Xrm.Page.getAttribute ("new_soldtobankdate").getValue();
var salesstage = Xrm.Page.getAttribute("new_salesstagercd").getValue();

if (salesstage == 100000008) {
Xrm.Page.getAttribute("new_pipelineage").setValue(solddate - createddate);
}

}

I'm hesitant because I'm trying to take a date field and put the difference in a whole number field. Will this work or am I off here?

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Community Member on at

Like (0)

Report

Thanks in advance for the help.

Was this reply helpful? Yes No
Verified answer

Dinesh Nanayakkara on at

Like (1)

Report

Hi Adam,

I would personally recommend to use a JavaScript library for your date manipulation. I could recommend Date.js or Moment.js (i prefer Moment.js) for date manipulation. It has many examples so you could never go wrong. Hope this helps.

Regards,

Dinesh

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I am receiving two errors with the code I am using listed in the original post -

When selecting a sales stage value (any) from the option set

When I pick a Sold Date,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I debugged and I get the date of createdon, the date of sold date (when entered), and sales stage proper value..... It can't be the conditional statement because salesstage does equal 100000008.. SO that leaves the calculations and setvalue... help please :)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I noticed and extra parentheses' behind the number, removed, retesting.

Was this reply helpful? Yes No
Rajkumar Rajaraman on at

Like (1)

Report

Try this:

var createddate = Xrm.Page.getAttribute("createdon").getValue().getDay();

var solddate = Xrm.Page.getAttribute ("new_soldtobankdate").getValue().getDay();

var salesstage = Xrm.Page.getAttribute("new_salesstagercd").getValue();

var calc = solddate-createddate;

if (salesstage == 100000008)) {

Xrm.Page.getAttribute("new_pipelineage").setValue(calc);

}

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

not sure what's wrong, here is the code I am down to -

function ageofrecord_onchange() {

var createddate = Xrm.Page.getAttribute("createdon").getValue();

var salesstage = Xrm.Page.getAttribute("new_salesstagercd").getValue();

var solddate = Xrm.Page.getAttribute ("new_soldtobankdate").getValue();

if (salesstage == 100000008) {

alert("score!!");

}

}

I get the same errors in the screen shot above. stuck, please help.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

trying this now Raj thanks

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

same two errors as listed above unfortunately :(

Was this reply helpful? Yes No