Date Criteria

S

Stacy

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!
 
S

Sprinks

Hi, Stacy.

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

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

Sprinks
 
S

Stacy

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

Sprinks said:
Hi, Stacy.

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

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

Sprinks


Stacy said:
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!
Click to expand...
Click to expand...
 
S

Sprinks

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


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

Sprinks said:
Hi, Stacy.

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

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

Sprinks


Stacy said:
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!
Click to expand...
Click to expand...
Click to expand...
 
Top