-
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
Role of Salesforce Implementation Partners in Data Migration
In today’s fast-paced business world, Salesforce stands out as a key player in customer relationship management and sales automation. Utilizing Salesforce Implementation Services can significantly…
Joining the #TrailblazerCommunity Groups Around your Location
As we all know meetup groups for Salesforce is going away and Salesforce has now invited us into their new platform - Trailblazer Community Groups to…
Salesforce Einstein – CRM Stepping Into The World Of AI
We belong to a hyper-connected world these days where each and every step we take is an onslaught of data. So for this world what…
Popular Salesforce Videos
Explain Standard Business Features of Salesforce?
Standard business features of Salesforce are Contact Management, Opportunity Management, Lead Management, Quote Management, Sales Management and Sales Forecasting. Watch the video to learn all…
Salesforce Checkout: Manage Your Subscription & Buy Licenses
Watch this video to understand how to manage your Salesforce subscription and buy licenses on your own. This makes an easy process even easier, this…
Powering Dynamic Gamification on Salesforce Communities With ScoreNotch
Gamifying your online community helps you drive highly-engaging user experiences. While you can host your community on Salesforce Experience Cloud, there are limitations with regard…
