Hi!! I’m trying to replicate an Alteryx conditional formula to Knime with the Rule Engine node. Could you guys help me ? IF [MONTH_BEG_DATE]>=[LFL_START_DATE] AND [MONTH_BEG_DATE] < DateTimeAdd([LFL_END_DATE],-30,‘days’) THEN ‘LFL’ ELSE ‘n_LFL’ ENDIF All the columns are Date format Thanks!

Hi there, no worries. I think you’ve got to divide the challenge into: Convert string to date (if not in date time format already) via String to Date&Time Calculate time difference “DateTimeAdd([LFL_END_DATE],-30,‘days’)” via Date&Time Shift Use rule engine Here’s the solution :wink: Since the Excel reader automatically converts the dates I spared step #1. https://hub.knime.com/mw/spaces/Public/latest/Knime%20Forum%20Support/Rule%20engine%20with%20dates Cheers Mike

How to combine conditions between dates?

KNIME Analytics Platform

izaychik63 October 22, 2019, 5:26pm 2

Please see this discussion

Also, look at

3 Likes