Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Brampton, Ontario, Canada

    Unanswered: Compare Current date to last year

    I have a tabel that consists of Ticket sales with a date field.
    It contains records for ALL of Last Years Sales.
    I'm creating a report that will compare this years sales to date,
    to Last Years.
    I'm using a query to get the info for Last Years.
    I need to know how to set the criteria for the date field to
    equal the Current Day & Month for Last year.
    In other words:
    If my table contains records with dates from Jan 1, 2002
    thru December 31, 2002
    How do I get all the records up to July 16, 2002
    (current day/month for Previous Year)

  2. #2
    Join Date
    Dec 2002
    Préverenges, Switzerland
    you can get the date one year ago with:
    dateadd("yyyy", -1, now())


Posting Permissions

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