Results 1 to 2 of 2

Thread: System Date for Access 2000

  1. Jul 12th, 2000, 10:40 AM #1
    Marita_l
    Marita_l is offline

    Thread Starter
    Junior Member
    Join Date
    Feb 2000
    Posts
    19
    I have a query where I want to pull only those records where The field for
    QuoteDate <=( Todays Date - 12 months).

    I have located Edate but Access 2000 seems to have a problem with this.

    In ORACLE I would just perform a calculation on SYSDATE - "12 months from
    now") ,not exact code, and be done with it. Is there something similair in
    Access 2000? or why want it work.

    Thanks in Advance,

    Marita

    Reply With Quote Reply With Quote
  2. Jul 13th, 2000, 01:49 AM #2
    Clunietp
    Clunietp is offline
    Guru Clunietp's Avatar
    Join Date
    Oct 1999
    Location
    USA
    Posts
    1,844
    use the DateAdd Function

    SELECT dateadd("m", -12, Date()) as TheDate
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width