View Single Post
 
Old 03-11-2021, 02:47 PM
Maramaschino Maramaschino is offline Windows 10 Office 2019
Novice
 
Join Date: Mar 2021
Posts: 1
Maramaschino is on a distinguished road
Default Calculate the first day of next month

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

Last edited by Charles Kenyon; 03-11-2021 at 07:43 PM. Reason: added link to tutorial
Reply With Quote