You need to sign in to do that
Don't have an account?
E_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.
Moved the message to relevant section. Hope you will get a quick answer here.
Thanks
Ankit Arora
Blog | Facebook | Blog Page
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.