-
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
Segments of Salesforce Data Cloud
Salesforce Data Cloud is a powerful platform that provides businesses with actionable data insights. Its features and architecture meet diverse business needs, making it a…
Automate to Upload Files on Amazon S3 Through Salesforce Apex
Amazon S3 is a web service offered by Amazon Web Services. Amazon S3 provides storage through web services interfaces. With the help of the following…
Salesforce Sharing and Security Features
Introduction: Salesforce provides different kinds of security levels like objects, field records, etc. Data is Stored in Objects, Fields, and Records in Salesforce. Salesforce uses…
Popular Salesforce Videos
Salesforce Mobile Publisher Demo
With Salesforce Mobile Publisher, you can create pixel-perfect mobile applications for employees, customers, and partners. Check out this video and learn all you need to…
Security in Salesforce - What Developers Must Know
Security in Salesforce 0:00 Introduction 3:00 Agenda 4:05 Data security 5:18 User Mode & System Mode 9:13 CRUD & FLS Data Model 10:45 Enforcing CRUD…
Salesforce Development Tutorial - sObjects
It is very easy to learn Salesforce with the world class training tutorial. Training is key for the right knowledge. Those who work as an…
