Skip to content

Dave Helgerson

Salesforce Software Development and Consulting

Menu
  • Contact
  • Resume
Menu

Category: Administrator

Add Days to a Salesforce Formula DateTime Field and Adjust for Daylight Savings Time

September 15, 2018September 18, 2018

Adding days to a DateTime field can lead to an unexpected time when the added date passes a daylight savings time. For example, if 7 days is added to 3/9/2018 10:00 AM, the new date will 3/16/2018 11:00 AM because it has passed the daylight savings time date. This occurs because the date is stored…

Read more
Categories: Administrator / Salesforce

Salesforce Date Formula for Finding the Next Business Day that Skips Holidays

February 3, 2018February 3, 2018

Finding the next business day using a Salesforce formula field can be challenging, and making the formula skip holiday dates increases the complexity. Below is what I’ve come up with after digging through many examples on the web, and borrowing logic that made sense. I would not call this great because it requires updating the…

Read more
Categories: Administrator / Salesforce

Report on Field Changes in Salesforce

November 26, 2012November 26, 2012

Tracking field history in Salesforce allows you to report on the original and new values of a field. This functionality can be very useful when determining who changed a field value and when it happened. This built-in change tracking has some limits: Only the following standard objects allow field history tracking: Accounts, Cases, Contacts, Entitlements,…

Read more
Categories: Administrator / Salesforce
Super Clone Pro
© 2023 Dave Helgerson | Powered by Minimalist Blog WordPress Theme