Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Location
    Raleigh, NC
    Posts
    183

    Red face Unanswered: Calculating and Formatting Dates and Times

    I have table called tblIRBReivews with field name "IRBNO" "ApprovalDate"and "ExpDate". I'm trying to creat reports that would give me lists of IRBNO with IRB approvals expiring within the next 3 months. Anyone know how to do this ?

    Thanks in advance
    Skharva

  2. #2
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    in your query, put the following into the Criteria of your ExpDate:

    <= dateadd("m",3,date())

  3. #3
    Join Date
    Sep 2003
    Location
    Raleigh, NC
    Posts
    183

    Lightbulb

    Thanks this wrks fine. But what if i want use today's date. For example what if i wann see all IRBNO that would expired within next three monts from today's date ?


    [i]Originally posted by jmrSudbury [/]
    in your query, put the following into the Criteria of your ExpDate:

    <= dateadd("m",3,date())
    Skharva

  4. #4
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    the date() part of the code snippit I included in my last post will use the system date.

Posting Permissions

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