Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2017
    Phoenix, AZ

    Exclamation Unanswered: Creating a report in Access 2013 to show values less than 30 days old

    Hello all,

    I have a table in Access 2013 that shows a list of Items and Dates.

    What I need to do is create a report and then create a button to give it an action "Only show Items less than 30 days from todays date then send an email to a person with the report in excel version"

    I have the sending email & converting it to excel action down. I have tried a few expressions I have found online about =DATEADD and =DATE()<30 but how would that apply to this specific column?

    For example, my table shows:
    Item Date
    One 5/20/2017
    Two 4/20/2017
    Three 9/30/2018

    I want to press the button and it filters out items "One" and "Two" then sends an email to someone in excel.


  2. #2
    Join Date
    Apr 2014
    Provided Answers: 33
    For date math, use DATEDIFF,


Tags for this 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