-
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
Salesforce Alternatives: Top 10 Competitors in 2021
Salesforce Alternatives: Top 10 Competitors in 2021 There are many Salesforce alternatives on the market today. In fact, with over 800 CRM platforms, the number…
What are Apex Basics? A Guide in 2023
The primary languages required to know in salesforce are: - Apex – It is used to write the business logic or we can say it…
Account Based Marketing With Salesforce – 4 Proven Strategies
Account-Based Marketing is ever-growing and a widely practiced B2B Sales and marketing technique that helps acquire potential companies as your clients with networking. The first…
Popular Salesforce Videos
Use Salesforce Notification Builder to Get Notifications to the Right Users in the Right Apps
Did you know you can use Notification Builder to create custom notifications for teams, task queues, and public groups? You can also replace standard notifications…
Salesforce To RDS Integration Through Dell Boomi | Salesforce Tutorial
Salesforce to RDS integration through Dell Boomi. This tutorial will cover the following points - 1. Introduction Take a quick glimpse at integrating accounts from…
All About Public Group in Salesforce
Public Group represents a custom group of users defined by an administrator. Users can be added to a public group individually, or based on their…