You need to sign in to do that
Don't have an account?
Ravi Mali
Formula field to extract Time from DateTime field .
Hi ,
Can anyone tell me the formula for Text type formula field to extract Time from DateTime field. I tried few ways but not getting the correct result.
User's TimeZone - (GMT-07:00) Pacific Daylight Time (America/Los_Angeles)
Ex - Start DateTime 4/25/2020, 4:00 PM , End DateTime -4/25/2020, 8:30 PM
Desired result : 4:00 PM - 8.30 PM
TIA.
Can anyone tell me the formula for Text type formula field to extract Time from DateTime field. I tried few ways but not getting the correct result.
User's TimeZone - (GMT-07:00) Pacific Daylight Time (America/Los_Angeles)
Ex - Start DateTime 4/25/2020, 4:00 PM , End DateTime -4/25/2020, 8:30 PM
Desired result : 4:00 PM - 8.30 PM
TIA.
You might find the section "Finding the Hour, Minute, or Second from a Date/Time" helpful in this document : https://help.salesforce.com/articleView?id=formula_examples_dates.htm&type=5
Anudeep