DateMacro For Netezza Execute
Hi,
I am new to SnapLogic and I am trying to execute a Generic JDBC for Netezza. The query works fine and output a table to Oracle. How can I add a macro on the fly for the previous month last date...
Forum Discussion
@tmiller @dstack, can you help?
I don’t know Netezza, but I think there was a similar date request using our expression language in this Community. Let me see if I can find it…
Edited to add the link to start with: Expression - Last Day of the Month - #6 by aaronb.
This might be a good starting point with a couple options.Hi,
How can I debug these expressions or check in values in Snaplogic?
Date.now().plusMonths(1).withDayOfMonth(1).minusDays(1)You can use the “Dynamic Validation” feature to see the results of expressions as you enter them. To view the results of sub-expressions, for example
Date.now().plusMonths(1), you can move the cursor to that part of the expression to see those results.Here’s a gif of DV in action:
