-
How can we get time from Date Time field in Salesforce?
Hi All,
How can we get time from Date Time field in Salesforce?
Thanks
-
1 Reply
-
Hi Sushant,
Try this formula, this works for any timezone (simply replace the +10 with whatever your timezone is relative to GMT):
IF(
ISBLANK(Departure_Date_Time__c ),"0",
TEXT(MOD(VALUE(
Left(
right( trim(TEXT(Departure_Date_Time__c) ),9),2))+10,24))
&":"&mid(right( trim(TEXT(Departure_Date_Time__c) ),9),4,2)
)Replaced 'Departure_Date_Time__c' with your datetime field, hope this helps.
Log In to reply.
Popular Salesforce Blogs
Unpacking Salesforce Experience Cloud: A Comprehensive Analysis
Introduction to Salesforce Experience Cloud Salesforce Experience Cloud, formerly branded as Salesforce Community Cloud, is a powerful tool created by Salesforce that provides businesses the…
Best Practices for Importing Data into Salesforce
The most efficient methods for arranging the data before moving it once you’ve decided which method is the best for importing or exporting your data. …
All You Need to Know About Salesforce Integrations
Integration In Salesforce, integration refers to the process of connecting and combining different systems or applications to enable the exchange of data and functionality. It…
Popular Salesforce Videos
The Rising Demand for Salesforce Experts | Salesforce Careers
With more than 500,000 organizations using Salesforce to drive key business results, the market is brimming with opportunities for Salesforce certified professionals. A quick job…
Multipurpose VF Component to Add Multiple Records on a Button's Click | Salesforce Tutorials
In this video, I will create a multipurpose VF component to add Contact records in a list on the click of a button then I…
Salesforce Connections 2018 Keynote - Ch. 4: U.S. Bank Is A Trailblazer
Salesforce Connections 2018 Keynote – Ch. 1: Corporate Positioning Salesforce Connections 2018 Keynote – Ch. 2: Ticketmaster Is A Trailblazer Salesforce Connections 2018 Keynote –…
