Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Help in MS Access

 
Kameswari Charan
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I want to select the birtdays of all employees in my office which falls on the current date in MSAccess.I have used the following code but it doesnot work..
SELECT BD_Details.CPFNo, BD_Details.[First Name], BD_Details.[Last Name], BD_Details.Birthday
FROM BD_Details
WHERE format(BD_Deatils.[Birthday],'mm/dd')=format(now(),'mm/dd');
Can anyone please help me.
Regards
Kameswari
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic