DateDiff

[David]

I need to filter out "Employees" with seniority of less
than 6 months according to a criteria line in my form (I
can't use a 180 day line because it's not quite accurate
enough.) If I key an "Enrollment date" criteria of
07/01/04, I need to eliminate hire dates of 01/02/04 and
after... i need to see hire dates of 01/01/04 and proir.

If I have a criteria date 10/01/04, I need eliminate hire
dates of 04/02/04 and beyond.
Can this be done in a simple statement, or do I need to
tear down each hire date and compare each to a torn down
criteria date?

Thnax - David

 

[tina]

try

< DateAdd("m", -6, EnrollmentDateCriteriaHere)

hth

 

[John Vinson]

If I key an "Enrollment date" criteria of
07/01/04, I need to eliminate hire dates of 01/02/04 and
after... i need to see hire dates of 01/01/04 and proir.

Use a criterion on Hire Date of

DateAdd("m", -6, [Enrollment Date])

 

[tina]

would "greater than" work?
i was thinking that it should be "less than" since he wants to see people
hired more than 6 months ago. though now that i think about it, maybe it
should be

<= DateAdd("m", -6, EnrollmentDateCriteriaHere)

per his example

what do you think?

If I key an "Enrollment date" criteria of
07/01/04, I need to eliminate hire dates of 01/02/04 and
after... i need to see hire dates of 01/01/04 and proir.

Use a criterion on Hire Date of

DateAdd("m", -6, [Enrollment Date])

 

[David]

Thanx y'all - That does what I need. Still waiting on the
Atty's to figure out what to with hire dates on the 1st of
the month. When they decide, I'll adjust - thanx again!!

-----Original Message-----

If I key an "Enrollment date" criteria of
07/01/04, I need to eliminate hire dates of 01/02/04 and
after... i need to see hire dates of 01/01/04 and proir.

Use a criterion on Hire Date of

DateAdd("m", -6, [Enrollment Date])

.