Date Input Node: how to set the default value to the execution time?

KNIME Analytics Platform
#1

Hello All,

Quick question. What is the simplest and easiest way to set the date input node's default value to execution time?

I passed today's date using a "Time Generator" node connected to a "Table Row to Variable" node. I then connected the date flow variable to the "Default Value: Date" within the "Date Input" node. I get an error which says "Errors loading flow variables into node : Can't parse date: 2016-12-30".

Any help would be much appreciated.

Thanks,
Joe

#2

The format is yyyy-MM-dd;HH:mm. if you are using a Tme Generation node, pass that through a time to string node and set the format to yyy-MM-dd;HH:mm, and then pass that to the table row to variable as you are doing. 

If you only want the date and not the time, you need to pass it through a Mask Date/Time node to remove the time. If you need seconds then this won't provide it, you'll have to use a string input node.

David

 

#3

By the way, you will still need to give the HH:mm as 00:00 in a date input node, so for today, it would be 2016-12-31;00:00

David

 

#4

Thanks, David! The holidays came around, and I didn't get a chance to reply.