13 Replies Latest reply on Jan 25, 2013 2:23 PM by Robin Kennedy

    REPOSTING DUE TO NO RESPONSES:  Include Date value of Null when prior business day is selected

    Jackie Klein

      I have a Parameter (Parameter PERIOD shown below) that was created to allow the user to select which Date component to view data by - by Day, Month, Quarter or Year.

       

      What I am trying to do, is if the User selects to view Data by Day, and the Date they select is the prior business day, I want the selection to include both values with the prior business day value as well as Null value.  I have a calculated field for the Date (DATE_FILTER shown below) that I am trying to modify to get it to work this way but not sure how to modify it.  Can you please let me know? 

       

      Parameter Period.png

       

      Calc Field DATE_FILTER.png