Date/Time Filters

• paul.j.kemna

  Ten Centuries

  Points: 1076

  More actions

  April 11, 2013 at 1:24 pm

  #292320

  When setting up filter parameters on tablix and graphs in BIDS/SSRS 2008, I have noticed that even though the paramater data type is set to Date/Time and the field being filtered is a Date/Time, if I select Date/Time as the data type on the filter configuration screen, it changes to Text the next time I look at it. On one report,Ii was able to get the Date/Time to stick only by removing the filtered query field in the dataset and recreating it. I have no idea why this resolved the issue.

  I am using a date picker for the parameter, which is in m/d/yyyy format. The data (which would be fed from a query in SQL server) is in default SQL date format of yyyy-mm-dd

  In all of my testing, it appears that the statement is being evaluated correctly, but this really annoys me.

  A) Why is it doing this?

  B) Is it safe?

  Thanks

  Paul