Search notes:

VBA function: dateAdd

dateAdd(…) can be used to add intervals to a given point in time:
sub addDateIntervals()

    debug.print "Date in a second:       " & dateAdd("s"   , 1, now)
    debug.print "Date in a minute:       " & dateAdd("n"   , 1, now)
    debug.print "Date in a hour:         " & dateAdd("h"   , 1, now)
    debug.print "Date in a week:         " & dateAdd("ww"  , 1, now)
    debug.print "Date in a weekday:      " & dateAdd("w"   , 1, now)
    debug.print "Date in a day:          " & dateAdd("d"   , 1, now)
    debug.print "Date in a month:        " & dateAdd("m"   , 1, now)
    debug.print "Date in a quarter:      " & dateAdd("q"   , 1, now)
    debug.print "Date in a year:         " & dateAdd("yyyy", 1, now)

'   ?                                        dateAdd("y"   , 1, now)

end sub
Github repository about-VBA, path: /functions/dateAdd.vb
The following expression evaluates to 2021-02-28:
dateAdd("m", 1, #2021-01-31#)

See also

dateDiff(…)
The date datetype.
date and time related and othr VBA functions.
SQL Server also has a function named dateadd.

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1740091002, '3.139.83.189', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/languages/VBA/functions/dateAdd/index(68): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78