Date Of Birth Query Question.... 1

[PaulinKC]

I've got a problem that I can seem to figure out. Guess that's why I'm posting here huh?

Anyway... here's my problem.

I've got a table - tblEmployee that has various fields, one in particular is DOB, which is the employee's Date OF Birth in MM/DD/YYYY format.

What I am wanting to do is run a query against just that table and have the results only show those records which the employee's DOB is the same as the current month - i.e Employee: Jane Smith DOB: 02/27/1900

Is there a way to show those records where the month in the DOB is the same as the current month? I looked at DateDiff so on and so on, but haven't found a resolution in any of my searches on here or anywhere else.

Some help would be GREATLY appreciated!

 

[tlbroadbent]

Select * From tblEmployee
Where Month(DOB) = Month(getdate())

The Month function is equivalent to DatePart(m, datevalue). If you want to get the best answer for your question read faq183-874 and thread183-468158.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[PaulinKC]

Terry thanks for your help! Worked great on the sql database. Now, another question if you don't mind, how would I do this if it were in Access 2000 format and not SQL? I know the same select statement won't work b/c I already tried it

Thanks again for your help!

 

[tlbroadbent]

Use datepart("m", date()) Or Month(date()). If you want to get the best answer for your question read faq183-874 and thread183-468158.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm