Select month from date

  • Thread starter Thread starter Mommio2
  • Start date Start date
M

Mommio2

Hi,
In my school database, I have birthdate in short date format in my
table. If I want to create a query to select all students with a birthday
during the current month, how can I split up birthdate to do that? Thanks!
 
In the Field row of your query, enter:
Month([birthdate])

In the Criteria row under this calculated field, enter:
Month(Date())
 
Wow, that was quick! Thanks a million! I couldn't have (almost) finished
this project without the help of people like you on this board!


Allen Browne said:
In the Field row of your query, enter:
Month([birthdate])

In the Criteria row under this calculated field, enter:
Month(Date())

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Mommio2 said:
In my school database, I have birthdate in short date format in my
table. If I want to create a query to select all students with a
birthday during the current month, how can I split up birthdate to do
that? Thanks!
Click to expand...
Click to expand...
 
I tried it, but it is making me enter the birthdate. Should I qualify it
with the database name.form name or something?

Allen Browne said:
In the Field row of your query, enter:
Month([birthdate])

In the Criteria row under this calculated field, enter:
Month(Date())

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Mommio2 said:
In my school database, I have birthdate in short date format in my
table. If I want to create a query to select all students with a
birthday during the current month, how can I split up birthdate to do
that? Thanks!
Click to expand...
Click to expand...
 
Never mind! IT WORKED this time! Gracias!


Allen Browne said:
In the Field row of your query, enter:
Month([birthdate])

In the Criteria row under this calculated field, enter:
Month(Date())

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Mommio2 said:
In my school database, I have birthdate in short date format in my
table. If I want to create a query to select all students with a
birthday during the current month, how can I split up birthdate to do
that? Thanks!
Click to expand...
Click to expand...
 
Back
Top