Removing the Time from query result...
Posted on 2005-04-29
I have this query which I've done in VB.NET:
"select Lots.LotID as 'ID', Lots.LotNumber as 'Lot Number', Lots.DateShipped as 'Shipped', Lots.Analyst as 'Analyst', Lots.PkgCode as 'Pkg', Lots.LotWeight as 'Weight', Lots.CustomerNumber as 'Customer' from Lots where Lots.LotNumber Like '" & Left(lotNumber.SelectedItem.Text, 4) & "%" & Mid(lotNumber.SelectedItem.Text, 6, 9) & "%'"
When the column "Shipped" is made, it shows the time 12:00:00AM. What code (using the query above) do I use to remove the time and just display the date?
Thanks in advance!