Scenario: In the vendor record, we have a status called ‘Charity Status’. While creating a vendor record, the status is set to ‘Initial contact’. The status of the vendor will converted to ‘Approved – Active’ after a time period. So the requirement is to calculate the number of days from the ‘Initial contact’ date/ create… Continue reading Formula to find the day difference between two Dates
Tag: Formula
To find the time difference and date difference
To find the time difference from a date, use the following formula in the script The formula to calculate the days
Formula to find Transfer price of an item.
>>Get the price and exchange rate >>To find transfer price use the formula, (parseFloat(price) / parseFloat(exchangerate)).toFixed(2).
To Add Days To Last Day Of trandate
You can use the below formula in a workflow after the field change of the trandate to add days to the last day of the trandate. (new Date((new Date(new Date({trandate}).getFullYear(),new Date({trandate}).getMonth()+1 ,0)).getFullYear(),(new Date(new Date({trandate}).getFullYear(),new Date({trandate}).getMonth()+1 ,0)).getMonth() ,(new Date(new Date({trandate}).getFullYear(),new Date({trandate}).getMonth()+1 ,0)).getDate()+30)).toLocaleDateString()
Set The Last Date Of Trandate
You can use the below formula to set the last date of trandate in the workflow triggering after a field change of trandate (new Date(new Date({trandate}).getFullYear(),new Date({trandate}).getMonth()+1 ,0)).toLocaleDateString()
Saved Search Formula Number of Weekdays between Two Dates
Saved Search Formula Number of Weekdays between Two Dates
Different Workbook formula for date wise dataset filtering
Workbook formula for date comparison and filtering
Search criteria to find the sales order which do not have the back ordered quantity
If a user need to create a transaction search to list out the sales orders which do not have any back ordered quantity in the line items, use the formula given below. case when {quantity}-nvl({quantitycommitted},0)-nvl({quantityshiprecv},0) > 0 then 1 else 0 endEnter 0
Search formula to find the latest date among the three dates
Scenario: If we need to find the latest date/the recent date among the three dates in a saved search, use the following formula in the search criteria. Formula(Date): CASE WHEN ({custrecord_project_first_expiry_date}>=NVL({custrecord_project_second_expiry_date},{custrecord_project_first_expiry_date})) THEN (CASE WHEN ({custrecord_project_first_expiry_date}>=NVL({custrecord_project_third_expiry_date},{custrecord_project_first_expiry_date})) THEN {custrecord_project_first_expiry_date} ELSE {custrecord_project_third_expiry_date} END) ELSE (CASE WHEN ({custrecord_project_second_expiry_date}>= NVL({custrecord_project_third_expiry_date},{custrecord_project_second_expiry_date})) THEN {custrecord_project_second_expiry_date} ELSE {custrecord_project_third_expiry_date}END )END
Excel Functions
COUNTBLANK The COUNTBLANK function returns a count of empty cells in a range. Cells that contain text, numbers, errors, spaces, etc. are not counted. Formulas that return empty text are counted. COUNTBLANK takes just one argument, range, which must be a cell range. SUMIF The Excel SUMIF function returns the sum of cells that meet… Continue reading Excel Functions