VBScript question

[jduenyas]

Hi All

I have created a function in the Edit Module in VBScript which given 2 dates return the elapsed time in Days,Hours, Mins, taking into account work hours (8AM - 6PM), weekends and holidays. So if an employee started a job at 4/6/2012 9:03:00 and fiinished 4/12/2011 16:60:00, the function will evaluate that to  5 Days, 7 Hours, 27 Minutes.

The function works correctly when running it from within the Edit Module however it does not when I try to deploy it from within an expression.

In the expression I pass to the function (TimeCard) the following:

=TimeCard(Date1, Date2) where Date1 and Date2 are fields in one of the tables which I read from our database.

Am I doing anything wrong that no values are returned?

Thanks

Josh

[#2]

Thanks

But I believe BEST in Qlikview world is copyrighted by our dear John Witherspoon 

Regards

Ashutosh