How to round down

  • Thread starter Thread starter Mike Kampff
  • Start date Start date
M

Mike Kampff

I'm sure this is really simple, but I'm stuck.

Here is one of the fields in my query
 
You might use the Int() function, as in:

Tenure: Int(DateDiff("d",[HireDate],Date())/365)
 
Or use the integer division operator (the reverse slash)
364\365 = 0
365\365 =1
366\365 = 1

Brian said:
You might use the Int() function, as in:

Tenure: Int(DateDiff("d",[HireDate],Date())/365)

Mike Kampff said:
I'm sure this is really simple, but I'm stuck.

Here is one of the fields in my query
-------------------
Tenure: DateDiff("d",[HireDate],Date())/365
-------------------
How do I drop the decimal places off the result? I don't
want it to round up, just drop the decimals.

Thanks
Click to expand...
Click to expand...
 
Back
Top