Post reply

filter based on Dates

  • February 17, 2012 at 3:11 am

    #391582

    Hi All,

    I am new in SSRS.

    In my table date formate is YYYY-MM-DD

    when i filter the data through parameters the date formate is taken MM-DD-YYYY so the data is not filterd based on dates.

    can any body plesae give the solutions

    Thanks & Regards,

    Kishore

  • February 17, 2012 at 5:38 am

    #1448422

    Hi

    You can change the report regional language (by clicking outside the report body in the properties on the right of the screen) to change the parameter default date format although I'm not sure which changes it to YYYY-MM-DD or you can change the format of your parameter in the SQL code

    declare @dateparameter as datetime

    set @dateparameter = '01-01-2012'

    select convert(varchar,cast(@dateparameter as datetime),111)

    There may be a better way not sure.

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

  • February 17, 2012 at 7:15 am

    #1448481

    Is your parameter a date type or text type?

  • February 18, 2012 at 2:53 pm

    #1448943

    If your column value should be a date type, then use this

    Format(column.value, "yyyy-MM-dd") --> Changes the datetime value to YYYY-MM-DD format

  • February 21, 2012 at 2:54 am

    #1449537

    my parameter is text type

Viewing 5 posts - 1 through 4 (of 4 total)

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