Date Difference rounding

A

Alex Martinez

Hi,
First of all Allen thanks for your help. When I use the text box to find
out the number of days between [completed] and [assigned] I get the correct
days, for example 11 days, but when I click on the text box I get 11.81315
days I just want 11 appearing only and without the user have the ability to
click on the text box without effecting it. Any tips will be appreciated.
Thanks
 
S

Steve Schapel

Alex,

It is not clear what method you are using to obtain the number of days,
but it looks like your [completed] and [assigned] fields contain a Time
as well as a Date. You could probably resolve this by using the Int()
function or the DateValue() function. If you are using an expression
that simply calculates [completed]-[assigned] you can change it to
Int([completed]-[assigned])
 
Top