Filtering out illogical values

[jmyjak]

Hello Alteryx Community,

I'm trying to find tool or formula that can help me find illogical year values in date time. For example if year is a value “0000” or “9999”.

I would like to highlight values that are not matching and filter them out for future investigation. 

I would be grateful for any tips! 

[messi007]

@jmyjak,

You can use filter tool with contains function.

Attached the workflow,

Regards,

[Qiu · Accepted solution]

@jmyjak 
I think you dont literally mean 0000 or 9999, rather than a common sense of year should be.

The next question is what will be common sense?
I think the alteryx gives a reasonable definition as below.

DateTime Functions | Alteryx Help

---

%Y

All four digits of the year ("2016").

2 or 4 digits are read. 2 digits are mapped to a range of the current year minus 66 to the current year plus 33. For example, in 2016, that's 1950 to 2049.

---

[jmyjak]

Thanks so much!!! Is there a way to avoid using column [Year]?