Dont know about mssql but in mysql there is a function like dayofweek So select becomes Select xxxxxx from abcd where x=y and y=z and dayofweek(datecolumn) not in (6,7) From: Calvin Omari [mailto:calvinebarongo@gmail.com] Sent: 16 August 2010 1:58 p To: Skunkworks Forum Subject: [Skunkworks] MSSQL - getting time different excluding weekends Hi, I am doing an ms sql select but i want to exclude week ends as i want am doing a different bewteen when a product was sold and when payment was done I need the diffrent between the sold date and paid date excluding weekends Any idea is highly appreciated Regards -- Our greatest fear is not that we are inadequate, but that we are powerful beyond measure. It is our light, not our darkness, that frightens us. Calvin Omari Systems Developer/Designer http://www.facebook.com/barongo