please help!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alex - 29 May 2006 23:13 GMT

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

Reply to this Message

Ofer Cohen - 29 May 2006 23:18 GMT

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()

Signature

Good Luck
BS"D

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

Reply to this Message

Alex - 29 May 2006 23:36 GMT

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()
[quoted text clipped - 6 lines]
> > How do I make a query where I search for somebody who has it's birthday
> > today. Thx

Reply to this Message

Ofer Cohen - 29 May 2006 23:52 GMT

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())

Signature

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
[quoted text clipped - 10 lines]
> > > How do I make a query where I search for somebody who has it's birthday
> > > today. Thx

Reply to this Message

Alex - 30 May 2006 00:07 GMT

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

Reply to this Message

Ofer Cohen - 30 May 2006 09:21 GMT

Your welcome, Glad I could help :-)

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

Reply to this Message