Recent content by Brsln

Thanks very much arnelgp. I had to change +1 to +2 as +1 was showing the following month. a month + 7 days should show 2 months after the current month. For example, VAT Date: 30/11/2022 VatDueDate: DateSerial(Year([VAT DATE]), Month([VAT DATE]) + 1, 7) gave me 07/12/2022, which is wrong...

I have a Dateadd function in a query, which is supposed to give me 1 month + 7days after whatever end of month date is in another text box The query is VATDueDate: (DateAdd("m",1,[VAT Date]))+7. However, if the month is a 31 day one I get the 7th and 30 day one I get the 6th. I should get the...