help..function from module in query (1 Viewer)

R

RachelM

Guest
I have been trying to use a module as a function in a query to give a date difference. It works fine, except that if I use a time value as well to give a half day it will still only give a whole number. I have found if I use the basic formula in the query I can get half numbers etc, but if I do the equivalent formula in the module I only get whole numbers e.g 1 instead of .5. This is actually a part of a bigger formula working out the difference between dates taking into account weekends and public holidays, which works fine, it is just this that is the problem.

If anyone knows the answer to this one I would very much appreciate some assistance.

RachelM
 

Users who are viewing this thread

Top Bottom