Solve "Birthday" days (any anniversary)

[marek.kandra]

Hello,

I have table with column "Birthday", ex. (12/05/1982), formated like date. I would to make report to show me:
1.) actuall day Birtday (ex. 12/05/2011)
2.) Birthdays which came in two days (mean 12/05 - 14/05)
3.) Birthdays for last 5 days (means 07/05 - 12/05)

I tried to make query like this:
Day(DateAdd("d",2,Date()))
Day(DateAdd("d",-5,Date()))
Day(DateAdd("d",0,Date()))

Month(DateAdd("m",0,Date()))

or also, based on forum I found to way how create special column:

This year Birthday: DateSerial(Year(Date()),Month([Datum_narodenia]),Day([Datum_narodenia]))
...but its returned: "Data type mismatch in criteria expresion"

Could you advise some working and simple query? which can by used in reports?

thanks a lot

Marek

 

[manojsikar1]

hi Marek,
I am also looking for the same answer..if you find plz post....

 

[jdraw]

Date info at
http://www.techrepublic.com/article/10-tips-for-working-with-dates-in-microsoft-access/6135056