hello,

I have a table with these columns:

IDsales, salesDate, salesmanID, itemDesc

I need an SQL querry to select all the sales from a certain date, with the summed sales groupped by salesmanID... The problem with the querry is that the data in the salesDate field is in a long format (with dd/mm/yyyy hh:mm:sss) and I dont know how to set the querry to disregard the "time" info, and take in account the "date" part only.

I am just a novice in SQL - all help is welcome )