locked
Date Range Defaults in SSRS RRS feed

  • Question

  • Hello and happy Friday!

    I have a several reports that accept date range parameters. These are not the textboxes that show you a calendar when you click the box, but just 2 simple textboxes (Startdate and Enddate). Is there a way for me to force the user to type in a date range in 'mm/dd/yyyy' format? Also is there a way where I can at least have 'mm/dd/yyyy' as a default in the textboxes so they know what format to use or prehaps a default date range for the current day dynamically hardcoded into the date range
    text boxes?

    Here is the code that I have in the dataset properties.
    Thank you all in advance.

    Select * from v_SQL_VIEW
    WHERE Dates
    Between @Startdate and @Enddate
    order by 1

    Dave SQL Developer

    Friday, November 1, 2013 7:07 PM

Answers