Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Calculate Working Days excluding Sat
Resolved my issue by removing select case CREATE FUNCTION WorkDays (IN :StartDate DATETIME, :EndDate DATETIME ) RETURNS INTEGER; BEGIN DECLARE :Var1 Integer; DECLARE :Var2 Integer; DECLARE :Var3 Integer; if...- caddy1
- Post #5
- Forum: Pervasive: Pervasive.SQL
-
Calculate Working Days excluding Sat
Hi Forgot to mention the function can be created but when i try to use the function in the select statement get this message pop-up [LNA][Pervasive][ODBC Engine Interface]Expression evaluation error. Statement select WorkDays('2009-01-01 00:00:00','2009-01-09 00:00:00')#- caddy1
- Post #4
- Forum: Pervasive: Pervasive.SQL
-
Calculate Working Days excluding Sat
Sorry its RETURNS INTEGER; not RETURNS DATETIME; Still doesn't work- caddy1
- Post #2
- Forum: Pervasive: Pervasive.SQL
-
Calculate Working Days excluding Sat
Every time i run this function getting an error not sure what i am doing wrong. Using Pervasive 9.71 CREATE FUNCTION WorkDays (IN :StartDate DATETIME, IN :EndDate DATETIME) RETURNS DATETIME; BEGIN RETURN (SELECT...- caddy1
- Thread
- Replies: 4
- Forum: Pervasive: Pervasive.SQL
