Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Natasha AliNatasha Ali 

Force a time to be 09:00:00 in formula (process builder) ??

Hi,
I'm using the following formula to set a date and time for another field: 
DATETIMEVALUE(TEXT(DATEVALUE([Session__c].Course__c.Knowledge_Module_Session_1__c)+266) +” 09:00:00")
Regardless of time changes and time zones, I need to set the time to be 09:00:00 everytime. Is there any way of setting the time as 09:00:00 and forcing it to stay like that?

Many Thanks,
Natasha 
 
Best Answer chosen by Natasha Ali
Lokesh KumarLokesh Kumar
It's because the date time is always stored in GMT timezone and it will get displayed based on the logged in user timezone. 

All Answers

Lokesh KumarLokesh Kumar
What is the issue are you getting with the current formula?
Natasha AliNatasha Ali
Hi Lokesh,
The formula works perfectly, it's just that I want the time to be set as 09:00:00 regardless of timezones (for some records the time is 10:00:00 due to time changes).

Many Thanks,
Natasha
Lokesh KumarLokesh Kumar
It's because the date time is always stored in GMT timezone and it will get displayed based on the logged in user timezone. 
This was selected as the best answer