Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to exclude weekends in computation of date using SQL
Message
From
01/10/2003 20:02:01
Evelyn Neri
Epn Inc.
Manila, Philippines
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
How to exclude weekends in computation of date using SQL
Miscellaneous
Thread ID:
00834041
Message ID:
00834041
Views:
73
in my table i have fields from and to date that i want to compute, so using SQL i use,

SELECT empno,(todate-frdate) as "mydate" from mytable

say todate=10/06/2003 and frdate=10/01/2003..

how do i compute the date so that i would give me a value excluding saturday and sunday?

IIF(dow(todate-frdate)!=6 or dow(todate-frdate)!=7) in SQL does not work.

any help pls?
Next
Reply
Map
View

Click here to load this message in the networking platform