Calendar Year is a text column but I need to filter for dates greater than 2011

[juanrivera63]

I have a report in paginated report builder with 3 columns

I want to only show data for years >= 2011

But the column Calendar YEar is text, how can I do this in query designer ? 

[Medina]

Hi juanrivera63

You can do the following:

1. Right-click on the dataset you want to apply the filter,
2. Select Filters
   1. Enter the following: CInt(Year)
   2. Change the data type from Text to Integer
3. Operator >=
4. Value 2011