Netezza syntax for extracting previous month data

[Former Member]

Hi Buddies,

I have a requirement wherein. i have to report the previous month data using DeskI reporting tool.

My database connection is Netezza...

I need to create a condition object at the universe level for the object "ORIG_DATE" to extract the previous month data.

I need the corresponding Netezza syntax to create a condition object on the field "ORIG DATE" to extract the previous month data and use this condition object at the reporting level to report the previous month data....

Need immediate help on this.. Am nearing the deadline...

Thanks in Advance !!!!

[Former Member · Accepted solution]

for more information please visit http://www.netezzaforum.com