scottklement.com

Found a solution using InLine SQL Function as follows:

Create or Replace Function NONWORKHRS(
facility VarChar(3)
,pmiBDate Date
,pmiEDate Date
)
returns Decimal(7, 2)
language sql
specific NONWORKHRS
not deterministic
not fenced
reads sql data
returns null on null input
Set Option ...

Will preface this is my first time trying to create a UDF. I created the function. The function is getting executed from the SQL statement correctly. Then I realized the value I was calculating in the function needed a set of non-workday hours removed from the sum. I thought, why not use another SQL ...