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
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.