As I told you, in this tutorial your yellow interface should only be used as the source of a second interface. And then you should just execute the second one (the first doesn't need to be executed, it will only be used as a view by the second one). If you need more info about that, ask your questions in the other thread : Yellow Interface :)
Try again your first solution with ODI variable.
But in the ODI variable, do a concatenation of a "space" with the date.
Example of variable refresh in Oracle :
select ' ' || <%=odiRef.getSysDate("yyyyMMddHHmmSS")%>') from dual
select ' ' || to_char(sysdate,'YYYYMMDDHH24MISS) from dual
In your KM step, call this variable. But prefix it with the name of the project code. Example : if your project code is PJ and variable is datevar, you must write #PJ.datevar. Or #GLOBAL.datevar if is it a global scope variable.