I want to craete a report in a Java application. I am basically working with java and using MS access as a database.
Some of the fields in the table of the database is of type Date/time.
I want to put a quey to retieve data from this date to this date.
for eg, i want to retrieve data from month January to February. So how do i go about and write a query which will split the date of dd/mm/yyyy and will select out the complete month as such.
Kindly explain with the code.