wood burning stoves 2.0*
The moose likes JDBC and the fly likes Help in MS Access Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Help in MS Access" Watch "Help in MS Access" New topic
Author

Help in MS Access

Kameswari Charan
Greenhorn

Joined: Jul 22, 2003
Posts: 1
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Help in MS Access
 
Similar Threads
date format
date problem
Date Format ,Please help!
Date formatting in java.
Happy Pi Day