Hi all,

I have the following MS Query which is displaying the 'DespatchDate' column as 'DateTime';

SELECT Customer.AccountCode, Customer.CustomerName, Product.ProductCode, SalesOrderHeader_1.DespatchDate, Sum(SalesOrderDetail.DespatchQty) AS 'Sum of DespatchQty'
FROM EnterpriseII5.dbo.Customer Customer, EnterpriseII5.dbo.Customer Customer_1, EnterpriseII5.dbo.Product Product, EnterpriseII5.dbo.SalesOrderDetail SalesOrderDetail, EnterpriseII5.dbo.SalesOrderHeader SalesOrderHeader, EnterpriseII5.dbo.SalesOrderHeader SalesOrderHeader_1
WHERE SalesOrderDetail.SalesOrderID = SalesOrderHeader.SalesOrderID AND Product.ProductID = SalesOrderDetail.ProductID AND Customer.CustomerID = SalesOrderHeader.CustomerID AND SalesOrderHeader_1.SalesOrderID = SalesOrderDetail.SalesOrderID AND SalesOrderHeader_1.SalesOrderID = SalesOrderHeader.SalesOrderID AND SalesOrderHeader_1.CustomerID = Customer.CustomerID AND Customer_1.CustomerID = Customer.CustomerID AND Customer_1.CustomerID = SalesOrderHeader.CustomerID AND Customer_1.CustomerID = SalesOrderHeader_1.CustomerID AND ((SalesOrderHeader.DespatchDate>=? And SalesOrderHeader.DespatchDate<=?))
GROUP BY Customer.AccountCode, Customer.CustomerName, Product.ProductCode, SalesOrderHeader_1.DespatchDate, Customer_1.AccountCode
HAVING (Customer_1.AccountCode<>'WRITEOFF')
I need this to convert to 'Date'. I don't want it to convert to the 'nearest' date to the time. Literally just need the time removed from the column so I can then do lookups to this column in Excel.

Anyone have a clue how to do this easily?

Many thanks in advance,

TM