Rounding - Date Calculation (1 Viewer)

R

RachelM

Guest
A number of days calculation in a module returns a rounded number in my query. The module is used as a function in a query and calculates number of working days between dates. If I run this equation in its most basic form in SQL it will give me the decimal value as well.

The part of the formula which I am having the trouble with is Wrkdays = datediff("d",startdate,enddate)
 

Users who are viewing this thread

Top Bottom