Timezone Bucket Formula
Sometimes it can be useful to label records based on when they arrived. The following approach shows how to create 2 formula fields. The first is to resolve the created date into an hour - either in…
Sometimes it can be useful to label records based on when they arrived. The following approach shows how to create 2 formula fields. The first is to resolve the created date into an hour - either in GMT / EST / PST. The second is to label the leads East or West depending on the hour of day.
Hour of day formula
Extract the hour the record was created - uses 24 hour clock (military time) 0 - 23 hours. Optionally adjust the timezone by subtracting 5 hours for EST, 8 for PST.
Created time GMT
VALUE( MID( TEXT( CreatedDate ), 12, 2 ) )Created time EST
VALUE( MID( TEXT(CreatedDate-5/24), 12, 2) )
Created time PST
VALUE( MID( TEXT(CreatedDate-8/24), 12, 2) )
This solution will only work for Standard Time and does not take into account Daylight Savings time.
Timezone bucket
Based on the hour of day, label the lead East or West. We've assumed the previous field was called Created_hour_pst__c. If the lead was created between 9am and 10pm PST we'll return "West", otherwise return "East"
IF( Created_hour_pst__c >= 9 && Created_hour_pst__c <= 22, "West",
"East"
)
How did we do?
Domain Formula
Has Activity Formula
