10 Replies Latest reply: May 31, 2012 5:48 AM by Ashutosh Paliwal RSS

    VBScript question

    Josh Duenyas

      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