Decimal places problem

[Pietro]

Hi,

I've a problem,I'm using the following equation in a query to get the
varience of dates between two dates in format 00.00 :
Format(DateDiff("s",[received],Now())/86400,"00.00")
Actually i need to get the value only if it's complete:
for eample if the result of the equation is 0.999999 i want it to be 0 not
1,but actually Access write it as 1
how can i do this ?

 

[John W. Vinson]

Hi,

I've a problem,I'm using the following equation in a query to get the
varience of dates between two dates in format 00.00 :

00.00 seconds? days? what's the unit?

Format(DateDiff("s",[received],Now())/86400,"00.00")
Actually i need to get the value only if it's complete:
for eample if the result of the equation is 0.999999 i want it to be 0 not
1,but actually Access write it as 1
how can i do this ?

I'm sorry, but this simply isn't making sense. You're calculating a time in
integer seconds; converting it to fractional days; formatting the fractional
days as a text string (e.g. 3 days 18 hours would be 3.75; and now you say you
want to round down.

What are the units of your desired "variance"? Seconds, days, what?
What precision do you want? Integer days, hundredths of a day?
What rounding do you want? Rounded down to the integer day?