File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
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
 
Consider Paul's rocket mass heater.
 
subject: Help in MS Access
 
Similar Threads
date format
Date formatting in java.
date problem
Date Format ,Please help!
Happy Pi Day