Hello Everyone,
I am an Alteryx rookie and am having issues with another one of my multi-conditional statements. I have tried changing the [created] data type from a date, to an integer, to a string and cannot seem to clear the error message in the formula. I continue to get the error message "the field ""is not contained in the record".
If [created]<="2019-01-01" THEN "2018"
ELSEif [created]<="2019-01-31" THEN "January"
ELSEif [created]<="2019-02-28" THEN "February"
ELSEif [created]<="2019-03-31" THEN "March"
ELSEif [created]<="2019-04-30" THEN "April"
ELSEif [created]<="2019-05-31" THEN "May"
ELSEif [created]<="2019-06-30" THEN "June"
ELSEif [created]<="2019-07-31" THEN "July"
ELSEif [created]<="2019-08-31" THEN "August"
ELSEif [created]<="2019-09-30" THEN "September"
Else "Other"
ENDIF
Thanks for the help!
Matt.