Date Range Check for Customers

Hi,

I am working on a data set from CSV file where I have a column called Effective date.

I want to create a validation check for the column where effective date should not be older than 1950-01-01 and should not be greater than 365 days from current date.

if there are any dates which are older than 1950-01-01 and greater than 365 days from current date it should be flagged in error log.

I am bit new to KNIME.

Can anybody help me out on which nodes to use and what to configure in those nodes to get the validation check created?

Help will be greatly appreciated.

A) Column Expression
B) Rule Engine + a flow variable created upfront (in case you use ISO formatted Strings)

can be used to solve the issue

1 Like

Do you want to use an “and” or “or” conjunction for your 2 conditions? “or” seems to make more sense. Try this:


If you’re reading a csv file, configure the CSV Reader node like this to change the data string into a date:

2 Likes

Did my workflow solve your problem? If so, please mark solved. If not, please provide more detail.

1 Like