File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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 REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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
I agree. Here's the link:
subject: MS Access and Date
It's not a secret anymore!