If Statement

[jlfromm]

I have file with a end date in it. I tried to create a if statement that If the end date is a certain date then use this date in the  QTR FYE column 

Example 

However this saying 

[apathetichell · Accepted solution]

your problem is the last part of your expression:

else "error" or 0 is written wrong for a few reasons:

1) Else is not a compare (elseif is).

2) "error" or 0 is litterally an expression comparing two values which cannot be compared (a string and a number)

3) This field is a date field it cannot have either a string, a number or a boolean value which your OR statement would return in it.

4) Try else null()

[binuacs · Accepted solution]

@jlfromm the last part of the else condition is not correct. you cannot use 'or' in the if else condition 

1. else ''error' or 0 is not correct, it should be else 'error'

2. you cannot use string or integer in the date type format field

you can write something like below

[jlfromm · Accepted solution]

Still get the same error

[binuacs · Accepted solution]

@jlfromm I can see there is a space after one of the ElseIF statement (3rd else if). please remove the space 

[jlfromm]

THANK YOU 

[rrahu07 · Accepted solution]

@jlfromm I agree with @binuacs. your last endif has space.