Unmatched(

Question

I cannot get this expression written out correctly.  Each line works on it's own, but when put together I am getting an Unmatched( error.

IF ([End Date] != [List of Dates] && [Start Date] != [List of Dates] then 24*60)

ELSEIF ([End Date] > [List of Dates] then DateTimeDiff([Start Date_Time],[Row+1:List of Dates], 'Minute')

ELSEIF ([End Date] > [List of Dates] then DateTimeDiff([Start Date_Time],[Row-1:List of Dates], 'Minute')

ENDIF

IraWatt · Answer

Thanks @DanielG 😆 !

DanielG · Answer

Nice writeup @IraWatt much more eloquently put than me.  😀

IraWatt · Answer

Hey @young351,

Few things too look at here though it hard to say without some example data.

Three points:

I think you have one too few brackets at the end.

You need an ELSE statement at the end.

Both your ELSEIF conditions are the same.

try writing it like this:

IF [End Date] != [List of Dates] && [Start Date] != [List of Dates] then 24*60

ELSEIF [End Date] > [List of Dates] then DateTimeDiff([Start Date_Time],[Row+1:List of Dates], 'Minute')

ELSEIF [End Date] > [List of Dates] then DateTimeDiff([Start Date_Time],[Row-1:List of Dates], 'Minute')

ELSE NULL()

ENDIF

The community has some quick and easy videos on formulas and the Formula Tool here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Writing%20Expressions

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com