Two Laptop Bag*
The moose likes JDBC and the fly likes MS Access and Date 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 "MS Access and Date" Watch "MS Access and Date" New topic

MS Access and Date

Duane Riech
Ranch Hand

Joined: Feb 27, 2003
Posts: 52
I have a MS Access table which contains a Date tag on each record.
I want to retrieve records based on:
Today - 1 month
Today - 2 weeks
Can anyone tell me the syntax?
Sam Moran
Ranch Hand

Joined: Sep 28, 2002
Posts: 86
I am assuming you want SYSDATE (minus) a number of days. If so, have you tried the following:
I hope this helps.

We make a living by what we get, we make a life by what we give!
Mathias Nilsson
Ranch Hand

Joined: Oct 13, 2003
Posts: 107

SCJP2 , MCP( 70-229 ) , Preparing For SCWDC
subject: MS Access and Date
Similar Threads
about date
How can convert DATETIME type to JAVA date type?
Date Format
Convert Datetype from Access database to Java 'DATETIME'
About convert datetype 'DATETIME' From SQL (access 2000)into JAVA