Filter for the current month

[Former Member]

Hi all,

Our client wants to see the report for the current month whenever he opens the report. We have a field called date which shows the date when PO was created in the format of mm/yyyy and mmm yy(JAN 2004 or JAN 2007. How should I create a filter report or Drill not Query to filter the data for the current month only.

Regards,

BOB

[Former Member]

Bob,

filter the data for the current month only.

It will work best setting up a filter at the Universe level. You don't mention the database vendor, but for instance if it was SQL Server you could use something like this:

select convert(char(11),getdate(),101)

Essentially you'll take the current date and modify it to conform to the MMM/YYYY format....

thanks,

John