You need to sign in to do that
Don't have an account?
BrandLeet
Parse out date/time from Opportunity Name
My opportunity names come in the following format:
FirstName LastName - DesiredProduct - 2017-10-19 18:21:55
I'd like to parse out the date/time from this and place date and time in separate fields. Is that possible? If so, how?
FirstName LastName - DesiredProduct - 2017-10-19 18:21:55
I'd like to parse out the date/time from this and place date and time in separate fields. Is that possible? If so, how?
TIMEVALUE(RIGHT(TRIM("FirstName LastName - DesiredProduct - 2017-10-19 18:21:55"),8)+".000")
DATEVALUE(LEFT(RIGHT(TRIM("FirstName LastName - DesiredProduct - 2017-10-19 18:21:55"),19),10))
DATETIMEVALUE(RIGHT(TRIM("FirstName LastName - DesiredProduct - 2017-10-19 18:21:55"),19))