groverarena
New Contributor
Joined 7 years ago
User Profile
User Widgets
Contributions
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 of the month. I tried documentation but it’s not helping much. Can somebody please guide? Details: 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)3.9KViews0likes4Comments