DateAdd()

Adds/Subtracts date units from a given date

DATE = DateAdd(
				
					
					
						datepart, 
					
				
					
					
						period, 
					
				
					
					
						date
					
				
				)

Argument	Summary
datepart	date part ('yyyy' year, 'q' quarter, 'm' month, 'y' day of year, 'd' days, 'w' week day, 'ww' week of year, 'h' hours, 'n' minutes, 's' seconds, 'l' milliseconds)
period	period
date	date object

Supports named-parameter calling allowing you to use the function like:

DateAdd(
   datepart=?, 
   period=?, 
   date=?
);

Supports passing parameters as a structure using ArgumentCollection:

DateAdd( ArgumentCollection={
   datepart : ?, 
   period : ?, 
   date : ?
} );