2 Replies Latest reply on Dec 7, 2013 8:01 PM by Ken Patton

    Dynamic Dating Parameter w/ Fiscal Calendar

    Jason Quint

      I've created a number of YTD and MTD metrics using a Current Period perameter b/c we use a fiscal period and i want my reports to be as of the most recent closed fiscal period.


      My problem is i have to go in and change that parameter every month on every workbook.


      I'd like to be able to set my parameter on some sort of a function that references today, and then what fiscal period does today fall into and then what is the period before this one.


      I've tried something like






      Then set that calculation as a custom date field, then reference that customer date as the source of the parameter, but it shows up as 12/30/1899.....


      Any and all help is appreciated.