Help

Re: Remove error in "Week Of" formula

622 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Kelly_Vorrasi1
6 - Interface Innovator
6 - Interface Innovator

Hi All,

I’m trying to adjust this formula to state “Needs Mix Date” instead of just showing an error when there is no {Mix Date} filled.

CONCATENATE(“Week of”," ",DATETIME_FORMAT(DATEADD({Mix Date},-DATETIME_FORMAT({Mix Date},‘e’),‘days’),‘M/D’))

I tried this but it’s not working

IF({Mix Date},CONCATENATE(“Week of”," ",DATETIME_FORMAT(DATEADD({Mix Date},-DATETIME_FORMAT({Mix Date},‘e’),‘days’),‘M/D’),’Needs Mix Date’)))

2 Replies 2
Claudio
6 - Interface Innovator
6 - Interface Innovator

The first clue is that the formula ends with “)))” but there is only one IF.
That means that you have an extra parenthesis or you have one or more parentheses in the wrong place.

Try this:
IF({Mix Date},CONCATENATE(“Week of”," ",DATETIME_FORMAT(DATEADD({Mix Date},-DATETIME_FORMAT({Mix Date},‘e’),‘days’),‘M/D’)),‘Needs Mix Date’)

Kelly_Vorrasi1
6 - Interface Innovator
6 - Interface Innovator

Thank you thank you!!