How to create Current Year Filter at Universe Level ?

[Former Member]

Hi,

I want to create a Current Year, Next Year and Last Year filters at Universe Level.

Can anyone help me with this.

I am using Netezza database and not able to find the appropriate date function in Netezza to accomplish this.

Any suggestions ?

Thanks

[Former Member · Accepted solution]

Hi,

You would somehow need to extract the Year part from the system date..

then

Current Year = Year

Next Year would be i.e Current Year + 1

Last Year would be i.e Current Year - 1

I guess this is the simple part... but you would need to find those functions on your RDBMS..

Hope this helps

Jacques