2 Replies Latest reply on Jan 17, 2019 9:28 AM by Gustavo del Gerbo

    Pentaho How do you use fieldnames in "Execute SQL Script" step

    Matthew Coyne
      Share This:

      I am wondering if anyone would be able to assist.  I need to get the current date/time at the time of the transformation running, minus 1 day from it.  Currently I am using 2 "Execute SQL Scripts" steps.  the first one is taking the current date/time and converting it to Epoch, then I am subtracting 86400 seconds from that:

       

       

      In the next "Execute SQL Script", I am converting back to date/time:

       

       

      Problem is I can not get the step to accept the fieldname.

       

      Any suggestions or a better way of doing this.

       

      Thanks

       

      Matt