please help!

[Guest]

How do I make a query where I search for somebody who has it's birthday
today. Thx

 

[Guest]

In the query, under the field that contain the BirthDate write
=Date()
That return the current date

In SQL it will look like

Select * From TableName Where [DateFieldName]=Date()

 

[Guest]

thx but that person I am looking for is born on 30.05.1980 , and if I tryed
doing what you told me, and it doesn't find him...but I think I am one stepp
closer...

In the query, under the field that contain the BirthDate write
=Date()
That return the current date

In SQL it will look like

Select * From TableName Where [DateFieldName]=Date()

--
Good Luck
BS"D

How do I make a query where I search for somebody who has it's birthday
today. Thx

 

[Guest]

Sorry, you are right.

Try
Select * From TableName Where Format([DateFieldName],"ddmm") =
Format(Date(),"ddmm")

Or
Select * From TableName Where Month([DateFieldName] ) = Month(Date()) And
Day([DateFieldName]) = Day(Date())

--
Good Luck
BS"D

thx but that person I am looking for is born on 30.05.1980 , and if I tryed
doing what you told me, and it doesn't find him...but I think I am one stepp
closer...

In the query, under the field that contain the BirthDate write
=Date()
That return the current date

In SQL it will look like

Select * From TableName Where [DateFieldName]=Date()

--
Good Luck
BS"D

How do I make a query where I search for somebody who has it's birthday
today. Thx

 

[Guest]

Thanks a lot Cohen! U're the best!:*

 

[Guest]

Your welcome, Glad I could help