Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 5 of 5 total

Tue, May 11 2010 11:49 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Anyone suggest a nice simple easy way to exclude weekends from a datefield BETWEEN start AND end??? Roy Lambert
Tue, May 11 2010 12:10 PM	Permanent Link
Uli Becker	Roy, > Anyone suggest a nice simple easy way to exclude weekends from a datefield BETWEEN start AND end??? Perhaps this link will help: http://ryanfarley.com/blog/archive/2005/02/14/1685.aspx Uli
Tue, May 11 2010 12:27 PM	Permanent Link
John Hay	Roy > Anyone suggest a nice simple easy way to exclude weekends from a datefield BETWEEN start AND end??? where extract(dayofweek from datefield) < 6 John
Tue, May 11 2010 1:23 PM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Uli As walking the dog and John reminded me Tim's built in a DAYOFWEEK as part of EXTRACT. Thanks for the info though. Roy Lambert
Tue, May 11 2010 1:24 PM	Permanent Link
Roy Lambert NLH Associates Team Elevate	John Strangely enough that's what came to me whilst walking the dog after stopping work Roy Lambert