AddDays ( theDate ; DaysToAdd )

Given a date and a number of days, returns the date that many days later.

Average rating: 3.7 (41 votes) Log in to vote

Andrew Sasaki - Show more from this author

Sample input:

AddDays ( 10/21/2004; 5 )

Sample output:

10/26/2004

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Date ( Month ( theDate ); Day ( theDate ) + DaysToAdd; Year ( theDate ))

Given a date and a number of days, returns the date that many days later.

Comments

		Chivalry, California Feb 2, 2009
Wouldn't theDate + DaysToAdd produce the same result?

		Thomas Seidler, London UK May 5, 2009
yes it does! ;) this function should be deleted it is redundant...

		Vaughan, Sydney, Australia Aug 10, 2011
... and yet is has a rating of 3.6?

		Robert Jackson, UK Jan 25, 2017
Maybe the comments got the votes :)

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.