Post reply

ssrs date format

  • August 5, 2015 at 3:08 am

    #310534

    Hi

    i am working on SSRS reporting i am facing some problem when in my table i have a columns which generate the date format like 2015-07-07 10:44:52.930 and when i am using this column in parameter to generate date wise sales but when i select the calendar and when i select the date its getting empty because of date format but when i enter the format like that its shows the data so, how can i change the date format in parameter

    can any one please help me

    thanks

    kishore

  • August 5, 2015 at 11:38 am

    #1817649

    One option might be to add a calculated field that returns just the date (no time) to your dataset and then use that to filter your dates.

    =DateValue(Fields!orderdate.Value)

  • August 7, 2015 at 4:13 am

    #1818043

    Hi its works thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply