Skip to Content
avatar image
Former Member

Filter for the current month

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jul 16, 2009 at 02:12 AM

    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

    Add comment
    10|10000 characters needed characters exceeded