Gridview to populate off of calendar.selecteddate

[dstrange]

Hi,

I'm trying to bind a calendar control's selected date to populate a gridview. I'm wondering if it has to do with date formatting?

SelectCommand="SELECT * FROM [tblTest] WHERE ([ReportDate] = @ReportDate) ORDER BY [ReportDate]" 

<SelectParameters>
<asp:ControlParameter ControlID="Calendar1"    Name="ReportDate" 
PropertyName="SelectedDate" Type="DateTime" />
            </SelectParameters>

 

[dstrange]

Spoke too soon.

I updated my where clause.

SelectCommand="SELECT * FROM [tblTest] WHERE(CONVERT(VARCHAR(10),reportDate,101)
= @ReportDate) ORDER BY [ReportDate]"