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
Solved! Go to 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()
@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
Still get the same error
@jlfromm I can see there is a space after one of the ElseIF statement (3rd else if). please remove the space
THANK YOU