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 of the month. I tried documentation but it’s not helping much.
Can somebody please guide?
FROM NZ_MODEL.ATTBN_PODS_MTH_ASSIGNMENT T
JOIN NZ_MODEL.ATTBN_PROVIDER_STG P
ON T.SRC_PROV_UNIQ_ID = P.SRC_PROV_UNIQ_ID
// Previous Month Last Date//
WHERE T.AS_OF_DATE_SKEY=20190131; (Need to replace that with macro)