Date Difference rounding

  • Thread starter Thread starter Alex Martinez
  • Start date Start date
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
 
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])
 
Back
Top