{"title":"Date Rounder","nodeType":"Manipulator","id":"*MLgWE0ePIyskKgJJ","factoryName":"org.knime.time.node.manipulate.datetimeround.DateRoundNodeFactory","factoryId":"org.knime.time.node.manipulate.datetimeround.DateRoundNodeFactory","path":["Other Data Types","Time Series","Manipulate"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>Rounds date columns to a specified granularity. You can adjust date values according to user-defined rounding strategies and precision, and replace or append the rounded values to the input table.\n <br />\n Frequently used to align dates to the start of months, quarters, or years for reporting and grouping.</p>\n        ","shortDescription":"Rounds a date.","keywords":["modify","ceil","floor","truncate","fields","hour","minute","second","millisecond","precision","day","weekday","month","quarter","decade","week","time"],"deprecated":false,"streamable":true,"tags":["Other Data Types","Time Series","Manipulate","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAwCAYAAABXAvmHAAAACXBIWXMAACE4AAAhOAFFljFgAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAMzSURBVHgB7ZlfSFNRHMe/526mzm2mzdjoj0uwtLS2pbXyDwv6o71oRoVlpI7oufcghIqiHqwI6skgIrJe+kMW9rDCYEk60BdFH4YIRpgoDlfM7XbuQt3N6zzXkdvkfuBwz378zt3ve37n/M4ZAxQUFBTiCUGMlNvtDsLBLPQDIbjcbrc3mr/DbjcHOTiEPh+Ct8vtdiEG1IgRjqCRzsMFoZ/C8U308TiavxA8AWkLf1ARwdeFGJjPQHhmVNxVyISEeAd9i1no8zwNhiPe6CN4M+H/ZoDi5QlxQSaBYKhlLtPzGQiqSBvhaTByiViEhNDAqAoZUDF8I2SyjkMWfdQKfQ5JCJ2jzLm+5B5oanbCaDIhkRgaGsLL9ueL7JICLDYbLFYrEgmjp1dSQFIuoUgUAfEm6QUwncT377ZimFaBSCxWG5qcTkn/F+3t6Pr8SWTbkpuL+nPn0TnhQq+vD9GwZBejeftZsMAkQCipvmmfyGYyGZd+qVqFDK1OZCNEBb//FwYmh+GZ6kfU70vfCFaYBJw6fQZyOFheieI9NqwGMV/m5HI0+xDKM/cvsg/MDOPV+DvIZdUFbE3dJGkfD0xgJShlNN6s+hL6l97pPsyE/HQPLJTp7/4f6Bj9GO5XGA9Aq85YcjyTgGh1XYq3b16jp7ubyX/k9yjdvB0im+dnf7gJ5bR682FEg0lAtLouRVpqGgw5OSKbRiM9i7WG4/gy9VVyE98ouYJlYwMDcut6WUVluLHiNDXg1sg9kc2xoQz5+rxlxybEJi7Q5IdbJDU0MywkTBUSsjBHjaEahpRspnEJI0AI+EiWI/ysZZx9gbiX0UiEwAsy8mWNSaiDTKNKh027W9YYpgy03rmNwcEBkc1qK0F9g/Q58OzpE3h6volsBYU70XzxkqR/54f3tInPAhO9wj94+AjLwSTAVrIXer1eZNtRWAidTivpX1S0C2pOnFzhXFjKPy9vG0pL94lsWp0OLPyX3wMn6k4Cdez+x6qqwm0lKLfReLM2r9NjY2MwGo1IJHw+n6RdUsDN69eQLCwsIR6TSEIW/uAIzLaoU9RmKmQ9EhgevDc4G7wMBQWFtcEfQpTSzD+5JcEAAAAASUVORK5CYII=","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 rounded dates."}],"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":"Date&time columns","description":"The date&amp;time columns whose values are shifted.","optional":false},{"name":"Round to","description":"The rounding strategy to apply, either round to the first or last value of the chosen rounding precision.","optional":false},{"name":"Exclude weekends","description":"Option to exclude weekends from the rounding. A weekend is defined as Saturday and Sunday.","optional":false},{"name":"Additional shift","description":"Option to shift the date to the previous or next date in the chosen resolution.\n<ul><li><b>Previous</b> : Shifts to the previous value. 12.12.24 rounded to the first day of the &#39;previous&#39; month will result in 1.11.24.</li><li><b>This</b> : Shifts to the this value, i.e., no shift at all.</li><li><b>Next</b> : Shifts to the next value. 12.12.24 rounded to the first day of the &#39;next&#39; month will result in 1.1.25.</li></ul>","optional":false},{"name":"Rounding precision","description":"The rounding precision. The date will be rounded to the first or last value of the chosen precision.","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":[]}