| Author |
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
or
Today - 2 weeks
etc.
Can anyone tell me the syntax?
Thanks
|
 |
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:
SYSDATE - 6?
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
|
|
|
0
