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