set a payment date of 2nd of month

  • Thread starter Thread starter Sarah
  • Start date Start date
S

Sarah

I am trying to use an update query to mark all purchase invoices received in
one month to be paid on the 2nd of the following month. I can't work out how
to fix the payment date as the 2nd of that month when the date of the
invoices varies. Can anyone help please?
 
DateSerial(Year(InvoiceDate), Month(InvoiceDate) + 1, 2)

(Don't worry, that'll work fine even for InvoiceDate values in December)
 
Sarah said:
I am trying to use an update query to mark all purchase invoices received in
one month to be paid on the 2nd of the following month. I can't work out how
to fix the payment date as the 2nd of that month when the date of the
invoices varies.
Click to expand...


Use the DateSerial function something like:

DateSerial(Year(invdate), Month(invdate)+1, 2)
 
Back
Top