top of page
Formula Repository
Sharing and storing helpful formulas along the way
Salesforce Help Docs
Formula Operators and Functions by Context
Examples of Advanced Formula Fields
Calculate Field Values with Formulas - main page with a bunch of sub-tabs
Formulas from the field
Date and Date/Time Fields
Unix Timestamp for Yesterday at 10pm
Use Case: Used in a Scheduled Flow that kicks off at 10pm and uses MuleSoft to get data from ezyVet for the last 24hr. However I wanted it specifically from 10pm the prior day so all of the API calls that follow are all using the same timestamp.
Formula:
TEXT(
UNIXTIMESTAMP(
DATETIMEVALUE( TODAY() - 1) +5/24
)
)
bottom of page