convert( varchar(12), events.EventStartDate, 105 ) as orderdate, <== I try to convert my text date from 12/1/2011 to a YYMMDD format and create a new field for it called ORDERDATE and then to use that new field to order the information

but the conversion doesn't seem to work ORDERDATE is exactly the same format as the original field no mater I tried style 112 and now 105 no diff...

any suggestions would be great.

Note that in the WHERE section EventStartDate > DATEADD( d, -1, GETDATE() ) <== this seems to work fine to select only todays date and later.

Note that in the WHERE section EventStartDate > DATEADD( d, -1, GETDATE() ) <== this seems to work fine to select only todays date and later.- 10spotdomain for all your domain and domain related needs

The right way to do this is to change the data type of EventStartDate to date. But as long as your session date format setting is MDY, the separated date string value will be implicitly converted to datetime for the comparison the DATEADD
function result. Note that this query works because EventStartDate contains only a date (without time component). Otherwise, rows less that 24 hours old would be selected.

Be aware that this will require a scan because of the function applied to the EventStartDate column. The underlying issue is that EventStartDate is not properly typed. Is it possible to change the date type? In that case, you could use
the query below, which can use an index on EventStartDate efficiently for botht he WHERE and ORDER BY: