You need to sign in to do that
Don't have an account?
Baz Denson
formula to add time to date
I aa trying to use process builder to create an event at 9:15 on the same date as another event. my formula is
DATETIMEVALUE(TEXT(YEAR([Event].StartDateTime ))+"-"+TEXT(MONTH([Event].StartDateTime ))+"-"+TEXT(DAY([Event].StartDateTime ))+" 09:15:00")
but I get a syntax error.
Can anyone assist with debugging please?
DATETIMEVALUE(TEXT(YEAR([Event].StartDateTime ))+"-"+TEXT(MONTH([Event].StartDateTime ))+"-"+TEXT(DAY([Event].StartDateTime ))+" 09:15:00")
but I get a syntax error.
Can anyone assist with debugging please?
DATEVALUE is needeed here ( YEAR(date) )
Always "Save" the formula every time because the last error message remains if not and you don't get the correct error message.
All Answers
DATEVALUE is needeed here ( YEAR(date) )
Always "Save" the formula every time because the last error message remains if not and you don't get the correct error message.
You would have get the tip of using DATEVALUE for YEAR as soon as you would have saved the formula by the process builder directly (we all have wasted time with this problem).