Thread: datediff()

You code is wrong There are three things you need to provide 1 the time value you want to see (days, months, years, etc) 2 the lower date 3 the upper date Example Elapsed = DateDiff("d",Date(),[DOB]) This shows the differenc ein days between the date of birht and today. Form more help type in DateDiff and press F1. David

I am well aware, I was short handing it cause the info between the parenthesis doesnt appear to matter. I had it set to "m" and "d" and neither worked.

apart from not being a mind reader, a number can't be <=0 AND >=2 Why not if expr<> 1 David

a number cant be both less than 0 and greater than 2 but a result can be both. plus, the result can be a range of numbers, the key is I am attempting to evaluate one table against multiple logical tests to get records that meet my criteria. the only part that doesnt work is this datediff() issue. I've even plugged the date diff into a query to test the results and evaluate true/false against...

Dear me David you really are a poor mind reader, it was obvious that expr and expr were different otherwise he would have written expr1 and expr2. why not just <1 and >1 or do we have decimal places involved? Brian Edit what is the full formula

actually the expr in the parenthesis are exactly the same. I am just evaluating [date ranges] out of tables vs. the current date to get records within my current criteria. its something along the lines of =dcount(*, 'tablename', criteria1 and criteria2 and criteria3 and datediff(expr)>X and datediff(expr)<Y) I don't have the exact code because its at work. Needless to say, I have got ...

Quote: Originally Posted by Myysterio actually the expr in the parenthesis are exactly the same. I am just evaluating [date ranges] out of tables vs. the current date to get records within my current criteria. Then David's comment in post 4 must stand as both Datediff's will produce the same result. Brian

but if you datediff("m", [tabledate], date()) in a query, you get a range of dates depending on which value of [tabledate] is being evaluated. I've plugged it into a query, I can clearly see the result it 1 but it is failing a logical evaluation even when I evaluate the query without all the dcount() nonsense. It also fails when you do the math manually with (now()-[tabledate])/30. You can ...

Try putting an extra set of brackets around the mathmatical part of the filter so that this will be processed first. Think BODMAS. David

Done, no go. Still is returning a weird result.