You need to sign in to do that
Don't have an account?
Amack Dawg
How to subtract Field Date Values in On-Click Javascript button
Scenario: Users need to be able to insert n-number of child records to the selected Parent record where n-number is determined by the integer difference of a Ceiling on two Date fields in the record.
Challenge: How can I retrieve an integer value by subtracting the record's 2 date values in Javascript? I am not even sure the value being returned is a date value (is it a string value)?
Specific code string:
Code block:
How can I converte my Creative End Date and Creative Start Date fields to be date fields to achieve the mathematical operation I need?
Challenge: How can I retrieve an integer value by subtracting the record's 2 date values in Javascript? I am not even sure the value being returned is a date value (is it a string value)?
Specific code string:
var weekCount = Math.ceil( (crtvtracker.Creative_End_Date__c - crtvtracker.Creative_Start_Date__c) );
Code block:
{!REQUIRESCRIPT("/soap/ajax/38.0/connection.js")} //Retrieve and store the selected accounts var CrtvTrackerIds = {!GETRECORDIDS( $ObjectType.Creative_ID__c )}; //Do a deeper query selecting required Parent fields var CrtvTrackers = sforce.connection.retrieve("Id,Name,Creative_Start_Date__c,Creative_End_Date__c","Creative_ID__c",CrtvTrackerIds); //Creating an array to store insertedCrtvScheds var insertedCrtvScheds = []; //... skipping some code checking here CrtvTrackers.forEach(function(crtvtracker){ alert(crtvtracker.Creative_End_Date__c); var CreativeEndDay = crtvtracker.Creative_End_Date__c.day(); alert(crtvtracker.Creative_End_Date__c.day()); var weekCount = Math.ceil( (crtvtracker.Creative_End_Date__c - crtvtracker.Creative_Start_Date__c) ); alert(weekCount); var schedToInsert = new sforce.SObject("Creative_Schedule__c"); alert( crtvtracker.Creative_Start_Date__c.daysBetween(crtvtracker.Creative_End_Date__c) ); for (weeknum = 0; weeknum < 0 ; weeknum++ ) { schedToInsert.Creative_ID__c = crtvtracker.Id; schedToInsert.Traffic_Status_updated__c = "On"; schedToInsert.Creative_Start_Date_updater__c = crtvtracker.Creative_Start_Date__c + (weeknum * 7); insertedCrtvScheds.push(schedToInsert); } //alert(crtvtracker.Creative_Start_Date__c); //Pass in the 'Creative Start Date' of the Creative ID //schedToInsert.Creative_Start_Date_updater__c = crtvtracker.Creative_Start_Date__c; });
How can I converte my Creative End Date and Creative Start Date fields to be date fields to achieve the mathematical operation I need?
It's specifically referencing this line:
But I have no idea how Salesforce's Date methods work in the Javascript button environment.
How can I convert a record's Date field values into something that I can perform math operations on?
Hello Amack,
Try this one:
I hope it helps you.
Thanks,
Yogesh Sharma