Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Date Parameter default issue in Report Builder

New to paginated reporting.    I am trying to connect to an existing dataset with calendar table. I have used the Date field( date data type)from calendar as a filter and trying to use the  paramet...
Report
d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
5 years ago

In the "General" tab for the parameter did you make sure to set the data type of the parameter to datetime ?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    d_gosbell 

     

    Yes. Data type is set to datetime.  My date field in calendar is set as the date as the dataset is used in many other reports and i cannot change that. 

    My requirement is

    1. Allow the selection of any date - I am able to do that 

    2. Default is to be set to today - Having trouble in setting Today() in default expression as error says type mismatch. I tried setting as text, but did not get default value