none
Showing From and To dates on the report.

    Question

  • Hi there,

    Is this the correct way to write the date from and To date that is selected as a parameter.  As an expression in the text box of the report?

    = "Date From" (Parameters!From.Value, "D") & " through " & "To" (Parameters!To.Value, "D")

    Many thanks for your help.

    Thursday, March 3, 2016 5:29 AM

Answers

  • After more searching and testing this is the way I did it.    You can change the text to suit your needs.  

    ="Report Period: " & Format("dd-mm-yyyy",Parameters!From.Value) & " to " & Format("dd/mm/yyyy",Parameters!To.Value)

    The From and To are what my date parameters are called. Change them to what yours are called. 
    • Edited by cr_banks Thursday, March 3, 2016 7:12 PM
    • Marked as answer by cr_banks Thursday, March 3, 2016 7:13 PM
    Thursday, March 3, 2016 7:12 PM