-
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
Why Should You Consider Migrating To Salesforce Lightning In 2022?
Salesforce has been in the industry for over two decades and has already carved its niche in the market. The CRM platform has been consistent…
Salesforce vs Hubspot: Which CRM is the Best Fit for Your Business Needs?
As companies grow and expand, managing customer relationships becomes a complex and challenging task. This is where customer relationship management (CRM) software comes into play.…
Why should You invest in Salesforce Consulting Services?
When it comes to successfully implementing Salesforce, having a trusted partner is not just beneficial, it's essential. A Salesforce Consulting Partner offers exceptional expertise, a…
Popular Salesforce Videos
How to Transform Sales Processes with Salesforce Anywhere
Salesforce Anywhere – a real-time interface that extends the power of Salesforce – is here to give sales leaders more visibility into what’s going on…
Salesforce Nonprofit Cloud Implementation Guide
While Salesforce offers a variety of tools that can help a nonprofit organization, the latest and greatest of these is Salesforce Nonprofit Cloud. Nonprofit Cloud…
Understanding Future Method | Difference Between Asynchronous and Synchronous Apex in Salesforce
In this video, Shrey explained Synchronous Apex and Asynchronous Apex in a simple way. He also explained the importance of the Future method in Salesforce.…
