please help!

  • Thread starter Thread starter Guest
  • Start date Start date
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()
 
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...


Ofer Cohen said:
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


Alex said:
How do I make a query where I search for somebody who has it's birthday
today. Thx
Click to expand...
Click to expand...
 
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


Alex said:
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...


Ofer Cohen said:
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


Alex said:
How do I make a query where I search for somebody who has it's birthday
today. Thx
Click to expand...
Click to expand...
Click to expand...
 
Back
Top