function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
E_rockE_rock 

Getting time value in a formula

Is there a function that I can use in a formula to determine the Time from a Date time field?   we have a need to create workflow based on if something occurrs before or after 4pm est.  Is this even possible?  Any help would be most appreciated, thanks.

Ankit AroraAnkit Arora

Moved the message to relevant section. Hope you will get a quick answer here.

 

Thanks

Ankit Arora

Blog | Facebook | Blog Page
Navatar_DbSupNavatar_DbSup

Hi,

 

You can create a formula field with the text type return and use below formula to get the system updated time

 

SUBSTITUTE(TEXT(NOW()),  TEXT( DATEVALUE(now())+1 ) , '')

 

Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved.