datediff()

[Myysterio]

I changed it from "four" to "several" a few seconds after I posted it. I didnt realize I had origionally posted four and then added the rest.

 

[Brianwarnock]

i have
datediff("m", [arrivaldate], date())=x
values I am getting for the first several records are
1,7,14,8,2,1,4
when I am evaluating if x<2 and x>0 I am getting false for ALL RECORDS.

But how can x be less than 2 AND greater than 0 try OR

Brian

 

[Myysterio]

because X is a result of doing the datediff(expr) function on a record in a report. the datediff() changes in every record. My results are 0-24 across all records, I am just trying to populate a text box with a number on a report.

 

[namliam]

But how can x be less than 2 AND greater than 0 try OR

Brian

The sample given is actualy X<2 and X>0
That is in more proper terms X>0 and X<2

I agree if it says X<0 and X>2, this is not possible should be OR...
X<0 or X>2

 

[Brianwarnock]

You are right Namliam, I guess I was so pissed off at repeating myself I lost my rag and didn't answer properly.

Brian