Date Formula Functions in Salesforce

Date Formula Functions in Salesforce

A support lead asks for a list of opportunities with no activity for more than 30 days. The answer is a date formula in Salesforce that compares the Last Activity Date with TODAY(). Salesforce date formula functions are the built-in functions (TODAY, NOW, DATE, DATEVALUE, ADDMONTHS, WEEKDAY and others) that create, convert, compare and calculate … Read more >>>

Query Records Created Today or Yesterday with SOQL in Salesforce

Salesforce SOQL query TODAY filter

To query records created today or yesterday in Salesforce, filter on the CreatedDate field with a date literal: WHERE CreatedDate = TODAY returns today’s records and WHERE CreatedDate = YESTERDAY returns yesterday’s. Both are SOQL date literals, so you write them without quotes, and they work for any standard or custom object that has a … Read more >>>

15 vs 18 Digit Salesforce ID [Difference Between Record Ids]

15 and 18 Character Salesforce Record IDs

To convert a 15 to 18 digit Salesforce ID, create a formula field on the object with the formula CASESAFEID(Id). The difference between a 15 and 18 digit record ID is only a three-character suffix, and this formula returns the 18-character version for every record, so you can reuse the field in reports, exports and … Read more >>>

How to Filter Out Null Values in Salesforce Report

salesforce report filter out blanks

To filter out null values in a Salesforce report, add a filter on the field, set the operator to not equal to, and leave the value box completely empty. The report then keeps only records where that field has a value, and every blank (null) row disappears. This is the answer to the common search … Read more >>>

How to Merge Contacts in Salesforce (Lightning Experience)

how to merge contacts in salesforce

To merge contacts in Salesforce Lightning Experience, open one of the duplicates, click View Duplicates in the Potential Duplicates panel, select up to three contacts, choose the principal record and the field values to keep, and click Merge. The other contacts are deleted and their related records move to the principal contact; the merge can’t … Read more >>>