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

    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.

    Help?

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    602
    Provided Answers: 31
    For date math, use DATEDIFF,

    DateDiff("d",[dateFld],Date())<30

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
  •