Put your scenario in a workflow. The Date manipulation is done with several KNIME nodes. One might also do that with a Java Snippet. With Date fields it is always the question how to store them, either as strings that can universally be stored and loaded or as UNIX timestamps or with the internal KNIME format. You always have to be careful. In a lot of Big Data storages the standard format for dates is:
yyyy-mm-dd a lot of programs can interpret that as a date format and even do calculations with it. Be sure to always check your results because date formats and operations can be notoriously tricky, even if you do not throw the whole localisation and timezone stuff at them.
kn_example_date_string_format.knwf (71.5 KB)