Compare dates in excel sheets

#1

Hi

I want to be able to read a date within certain rows/column in excel and compare them with today’s date and if it is say 2 days from that date, do something.

Any ideas?

0 Likes

#2

Hi there @MorgWilshaw,

for reading use Excel Reader with option what rows/columns to read. If your input date column is read as string use String to Date&Time node. Then using Date&Time Difference node get difference from today’s date. Then Rule Engine, Column Expressions or some other node might help you depending what this “do something” means :wink:

If you get stuck feel free to ask and we’ll figure it out.

Br,
Ivan

1 Like

#4

The only issue here is, the dates are on a specific row. Row 4. But across every column, so is there a way to read rows?

0 Likes

#5

Excel Reader has rows to be read on configuration…

1 Like

#6

Hi there @MorgWilshaw,

as @izaychik63 pointed out there is option to read specific columns/rows from Excel Reader node.

ExcelRowOpt
Additionally after you read this data into KNIME you will need to use Transpose node in order to follow my approach in previous reply.

Br,
Ivan

1 Like