jQuery in Action, 3rd edition
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 OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 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: http://aspose.com/file-tools
subject: MS Access and Date
It's not a secret anymore!