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.