{"title":"Date Modifier","nodeType":"Manipulator","id":"*LjEOMsJyCgHOEyLb","factoryName":"org.knime.time.node.manipulate.modifydate.ModifyDateNodeFactory2","factoryId":"org.knime.time.node.manipulate.modifydate.ModifyDateNodeFactory2","path":["Other Data Types","Time Series","Manipulate"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>Modifies date&amp;time columns by appending, changing, or removing the date component. You can append a date to time columns (output: Date&amp;time (Local) or Date&amp;time (Zoned)), change the date in local or zoned date&amp;time columns, or remove the date (output: Time).\n <br />\n Useful for normalizing date columns or extracting time components for time-based analysis.\n <br />\n <i>Note: This node does not perform shifting operations. Use the Date Shifter node for that purpose.</i></p>\n        ","shortDescription":"Modifies date information of a date&time cell.","keywords":["modify","date","time","fields","year","month","day"],"deprecated":false,"streamable":true,"tags":["Other Data Types","Time Series","Manipulate","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABHNCSVQICAgIfAhkiAAAAONJREFUOI2V0zFKRDEQxvHfExcWVxHtBDuPsOAF7O09gKWtICi8zsp7WG2lvScRa8VGEEFwY7GJvI3JRgeGyZuZ//cmJKFsB7jFS4xdpa9o+3hGwD1G/4HhJsJv2G41rxVy0xhH2BjkN3H5F4EQ4xh32MMWZjhsTXSKeRRJ/o7XuL5aBZ/gK4OH/ojdGnyMzxVw1Tscxb2OM9FrXPR9Xx051Z4KyuexJ4QQfvLJsryHATjH2eAnNWhJYCeKfFicglygNQGLuz4pbPMXlAuki5TOu2hdV39L69XK8hjV79YzDY26bzd5mczf0+4qAAAAAElFTkSuQmCC","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Input table","description":"Input table containing date&amp;time columns."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Output table","description":"Output table with modified date."}],"dynInPorts":[],"dynOutPorts":[],"additionalSiteInformation":{"url":"https://update.knime.com/analytics-platform/5.12","trusted":true,"enabledByDefault":true,"name":"KNIME Analytics Platform 5.12 Update Site","version":"5.12.0"},"dialog":[{"sectionName":"Options","fields":[{"name":"Modification","description":"Defines the action to be performed on the selected columns. The date can be changed, appended, or removed, with different columns being eligible for each action. For example, only time columns can have date appended, while local date&amp;time columns can only be modified or have their date component removed.\n<ul><li><b>Change</b> : Changes the date of a date&amp;time column, leaving the time zone unchanged.</li><li><b>Append</b> : Appends a date to a time column, resulting in a date&amp;time column. A time zone can optionally be set.</li><li><b>Remove</b> : Removes the date and time zone information from date&amp;time columns, leaving only the time.</li></ul>","optional":false},{"name":"Date","description":"The date to use when changing the date of date&amp;time columns or appending a date to time columns.","optional":false},{"name":"Time zone","description":"The time zone to use when appending a date to time columns.","optional":false},{"name":"Date&time columns","description":"The date&amp;time columns whose values are modified.","optional":false},{"name":"Output columns","description":"Depending on this setting, the output columns will either replace the modified columns, or be appended to the table with a suffix.\n<ul><li><b>Replace</b> : Replaces the selected columns by the new columns.</li><li><b>Append with suffix</b> : Appends the selected columns to the input table with a new name that is the previous name plus the provided suffix.</li></ul>","optional":false},{"name":"Output column suffix","description":"The suffix to append to the column names of the new columns.","optional":false}]}],"links":[],"kudos":[],"kudosCount":0,"bundleInformation":{"bundleVersion":"5.12.0.v202606171548","bundleName":"KNIME Date and Time Handling","bundleSymbolicName":"org.knime.time","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.base","featureName":"KNIME Base nodes","featureVersion":"5.12.0.v202606261225","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*bjR3r1yWOznPIEXS"},"frequentSuccessors":[]}