Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thanks
But I believe BEST in Qlikview world is copyrighted by our dear John Witherspoon
Regards
Ashutosh