Filtering out illogical values

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!

Date Time

Data Investigation

Accepted answers

Qiu

@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.

1220-jmyjak.yxmd

All comments

messi007

@jmyjak,

You can use filter tool with contains function.

Attached the workflow,

Regards,

Contains_20211220.yxmd

Qiu

@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.

1220-jmyjak.yxmd

jmyjak

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703