You need to sign in to do that
Don't have an account?
BobP
I have a formula field with a formula that is showing the incorrect time.
I have a date and time field that i am trying to just get the time from the that field. When I use this below format it gives me the time 5 hours ahead of EST. so the time in the field is 12:00pm it displays 5:00PM
(TIMEVALUE(SchedStartTime)
I guess i need to add the time zone to this formula on my time formula field but I am not sure how
(TIMEVALUE(SchedStartTime)
I guess i need to add the time zone to this formula on my time formula field but I am not sure how
The datetime in salesforce is always stored in GMT (UTC). You can try something like below. Check below references.
https://developer.salesforce.com/docs/atlas.en-us.formula_date_time_tipsheet.meta/formula_date_time_tipsheet/formula_using_date_datetime.htm
https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000A8cuYSAR
Please mark as Best Answer if above information was helpful.
Thanks,
I found a formula that mostly works below but when there is a 12:00PM value in the schedule start date field, it shows as 12:00AM in my formula field. Have you ever seen this issue before?