5min

nextAnniversary()

Given a date, returns the next upcoming anniversary of that date.
Syntax
nextAnniversary(anniversaryDate, fromDate)
anniversaryDate - the Date value to be evaluated by the function.
fromDate - (optional) the Date from which to find the next instance of anniversaryDate.
Return type: Date 
Sample usage
nextAnniversary(birthDate) returns the date one year after birthDate.
nextAnniversary('2018-05-24', '2021-01-01') returns 2021-05-24.
Supported data types
Input type
Return type
Logic
﻿Date 
﻿Date 
If a Date value is passed, the year will be incremented by 1. If the optional fromDate parameter is passed, the year will either increment or decrement by the difference in the year values, depending on whether fromDate is before or after anniversaryDate.
Unsupported data types
﻿Null 
Unsupported data types return Null.
Aliases
birthday returns the equivalent of nextAnniversary(birthDate).
anniversary returns the equivalent of nextAnniversary(startDate).
﻿

Updated 07 Dec 2021

Did this page help you?

Yes

UP NEXT

number()

Docs powered by archbee

TABLE OF CONTENTS

Input type	Return type	Logic
Date	Date	If a Date value is passed, the year will be incremented by 1. If the optional fromDate parameter is passed, the year will either increment or decrement by the difference in the year values, depending on whether fromDate is before or after anniversaryDate.
Unsupported data types	Null	Unsupported data types return Null.