I have a datagrid displaying entries by users showing user, amount of time, date entered, and description bound to a dataset. Im trying to filter the dataset on the DateTime column but get an error. Here's the code:
private void dgSummaryFilter(string SortColumn, string strFilter)
        {
            // Apply filter to the Job Summary dataset, enable button to remove filter, and bind Job Summary datagrid
            if (SortColumn=="TimeStamp")
            {
                Global.dsJobSummary.Tables[0].DefaultView.RowFilter = SortColumn + " = " + strFilter;
            }
            else
            {
                Global.dsJobSummary.Tables[0].DefaultView.RowFilter = SortColumn + " LIKE '*" + strFilter + "*'";
            }
                btnShowAll.Enabled=true;
                dgSummary.DataSource = Global.dsJobSummary.Tables[0].DefaultView;
                dgSummary.DataBind();
        }

Im pretty sure its to do with the filter string on the datetime column. How do i concatenate the string?

Hmm, looks like it should work but I will drop just a few suggestions you could try.

For concatentating the date, you will have to put it into a DateTime object class and then output it with the "YourDateTimeObject.ToShortDateString()" method to get the short date format which should be MM/DD/YYYY.

Next, I don't know for sure but do you need a pair of single tickets encapsulated by quotes around your strFilter on the line above the one that looks for the wildcard? I haven't really filtered from the dataset. I read somewhere that the app server isn't built for that and should be best left to SQL if you have a lot of EU.