Hello, thank you all for providing this valuable forum.



I am trying to calculate the first day of next month based on the insert date and time field. I reviewed the tutorial and the section that I thought would contain the answer does not appear to work for my purpose. the result after updating the field is as follows and today's date is March 11,2021.

Calculate the day & date of the nth day of next month

Monday, 4 January 2021 (the result after updating the field)

This is the instruction from the tutorial:
Note: Increasing the ‘day’ variable returns the nth day of this month (eg day = 1 gives the 1st of the month, whilst day = 2 gives the 2nd of the month, and so on). The field includes code to ensure that the calculated date does not exceed the last day of next month.

Any help is appreciated.

Thanks

I suggest you read the tutorial's Introductory Notes, especially the part about Internationalization Issues...

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]