-
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
Benefits of Salesforce Native Applications for The Growth of Businesses
Salesforce has emerged as a key player, providing a versatile platform for organizations to manage their customer relationships, streamline processes, and drive growth. One of the…
AWS Cloud Basics | Salesforce Trailhead Guide
In this blog, we will be taking a look at the topic of AWS Cloud. As we all know Cloud computing is the on-demand provision…
9 Tips to Keep Your Data Secure in Salesforce
The increase in remote working and reliance on automation makes many businesses make extra efforts to enhance the Salesforce security. Cybercriminals are on the rise…
Popular Salesforce Videos
Highlights of the Salesforce Winter '22 Release for Nonprofits
The video includes both Winter ‘22 Salesforce Platform updates and Nonprofit Cloud tools. Chapters: 0:00 General Salesforce.com Platform Updates 8:13 Salesforce.com Release for Fundraising and…
Is Trailhead enough to crack Salesforce Interview?
In this video, Shrey answered one of the most asked questions related to Salesforce Interview. Let's see how beautifully Shrey answered this Question. We hope…
Salesforce Admin 201 Training for Beginners: Different Types of Relationship in Salesforce
The Salesforce Certified Administrator program is designed for individuals who have experience as a Salesforce administrator. The program encompasses the breadth of applications, the features…
