You need to sign in to do that
Don't have an account?

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:
Many Thanks,
Natasha
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
All Answers
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