Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2006

    Unanswered: Date Issues in Access XP query

    I am trying to create a query to append info from one table to another. I need it to create a Month field (where the Month Name is the current month) and a Due date field (where the due date is the 15th of the next month unless it falls on a friday or saturday) I was using
    Month: MonthName(Month(Date()))
    to find the Monthname of the current month
    DueDate: Month(Month(Date())+1) & "15"
    to find the due date
    This worked fine until this month. I cannot get it to work in December. I am sure there is a simple solution but I am not very good at database queries.

    Please help my boss wants this database asap!!!

  2. #2
    Join Date
    May 2005
    Nevada, USA
    Provided Answers: 6
    Try the DateAdd() function, which should handle December to January properly.

Posting Permissions

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