5 Replies Latest reply: May 14, 2013 6:26 AM by Srini VEERAVALLI RSS

    Any Idea on changing this statement

      hello experts,
      I need to create a statement that will give me data for QTD only, for instance from 04/01 to date. However, I want make sure that my BI system will always return the correct data as the dates changes e.g. for this quarter it should run from 04/01 to 06/30. Then when it gets to July 1st it will start another quarter.. Any idea on how I can alter the below statement to fit my requirements

      FILTER("Fact - Project Budget"."Current Budget Cost" USING ("GL Calendar"."Fiscal Date" > timestamp '2013-04-01 00:00:00'))

      many thanks