Date Criteria

[Guest]

I need help setting a date criteria. I have all the employee start dates in
a date/time col. EXP. (08/25/2001). I need to sort by month.

EXP. All employees who started in the month of January, regardless of the
year. I can only make it sort with a year included or specific date.

Please HELP!

 

[Guest]

Hi, Stacy.

Use the DatePart function to return the month, e.g., for August:

DatePart("m",[TestDate])=8

Sprinks

 

[Guest]

Thanks
I copied that formula and a box pops up with Test Date and a blank. What do
I put in there?

Hi, Stacy.

Use the DatePart function to return the month, e.g., for August:

DatePart("m",[TestDate])=8

Sprinks

I need help setting a date criteria. I have all the employee start dates in
a date/time col. EXP. (08/25/2001). I need to sort by month.

EXP. All employees who started in the month of January, regardless of the
year. I can only make it sort with a year included or specific date.

Please HELP!

 

[Guest]

Sorry, Stacy. I cut and pasted my expression from my database and forgot to
change it. Change "TestDate" to the name of your date field. Do not include
the quotes, but include the brackets.

Hope that helps.

Sprinks

Thanks
I copied that formula and a box pops up with Test Date and a blank. What do
I put in there?

Hi, Stacy.

Use the DatePart function to return the month, e.g., for August:

DatePart("m",[TestDate])=8

Sprinks

I need help setting a date criteria. I have all the employee start dates in
a date/time col. EXP. (08/25/2001). I need to sort by month.

EXP. All employees who started in the month of January, regardless of the
year. I can only make it sort with a year included or specific date.

Please HELP!