-
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
Building a High-Performing Salesforce Development Team
Industries with the most sensitive data heavily use Salesforce because it is known to be feature-rich and secure. It is the number one CRM on…
Learn How to Create Record Using Flow in Salesforce
Go to Setup, enter flow in Quick Find then select Flows. Click on New Flow. From the template, select Screen Flow. Go to Object Manager…
Integrating AI into Salesforce CRM: Best Practices
Table of Contents Introduction Best practices for integrating AI into Salesforce CRM Understand Your Business Objectives Choose the Right AI Tools Prepare Your Data Start…
Popular Salesforce Videos
Introduction to SFDX Deploy Tool for Windows | Salesforce Integration Tutorial Series
In this tutorial, we're going to learn about SFDX Deploy Tool for Windows. SFDX Deploy Tool helps you to deploy metadata from one Salesforce org…
External ID In Salesforce | Salesforce Training
In this video, you will learn how to use External ID in Salesforce, usage, limitations and implementation of External ID in Salesforce. The following points…
How to Create Seamless Buying Experiences | Salesforce CPQ & B2B Commerce
B2B buying is evolving as buyers want a better, more personalized experience when shopping for their businesses. But Salesforce has that covered. Here are 4…
