i am using SSRS and getting my data from mysql using odbc.now my problem is transactions.CheckDate
returns date with time.i just want the date part.please help to display only the date part in my report.
SELECT transactions.price, transactions.CheckDate, products.image_name AS `Product Name`, products.id
FROM transactions, ShoppingBasket, ShoppingBasketItems, products
WHERE transactions.id = ShoppingBasket.TransactionID AND ShoppingBasket.pkID = ShoppingBasketItems.ShoppingBasketID AND
ShoppingBasketItems.ProductID = products.id AND (transactions.state = 1)