0 Replies Latest reply: May 27, 2011 2:09 PM by user2097024 RSS

    Rolling Fiscal YR reporting - trying to eliminate hard-coding

    user2097024
      Hello,
      I'm trying to create an embedded report that shows sales order history for only the current fiscal year. The only way I've been able to get the report to run correctly is by hard-coding the dates, but I'm trying to get away hard-coding. I've tried YEAR(invoice date) = YEAR(current_date), but this shows calendar year. I've also tried YEAR(Invoice Date) = valueof(NQ_SESSION.CURRENT_YEAR), but this pulls all dates b/c it is a session report.

      Is all date fields in analytics mapped to custom fiscal years set by Oracle? And, if it does map, then can anyone give an example of case statement or function to try?

      Thanks.