I am new in using KNIME and i need to filter all records that have a yesterday Date.
Example today is 09/10/2019 and i need to get only records that have a date of 9/9/2019 and write it in the database. The date should be dynamic also not fix tomorrow is 9/11/2019 then i should only get the records that have a date of 9/10/2019. can someone please guide me on how to do this in KNIME? Thanks!
Use the DateTime difference node, where you compare the date in your database with the current date.
See this wf days_diff.knwf (15.2 KB)
gr. Hans
2 Likes
Nice this is what i am looking for. Thanks for the help 
Problem is now solved
2 Likes
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.