Skip to Content
0
Former Member
Nov 25, 2011 at 07:08 AM

exclude weekend query

301 Views

Hi expert,

I already create udf for date start( u_start ) and date end ( u_end ) column in SO,i just want to know how to create simple query that can exclude weekend like saturday and sunday, example from 2/5/2011 until 25/11/2011 has 24 days,so i want minus all weekend like saturday and sunday,so i can get 18 day,can someone help me about this......