Skip Ribbon Commands
Skip to main content
SharePoint

Date Functions

The most common date functions are provided in the table below. In addition the description, syntax, arguments, and an example have all been provided.
 
Function Name
Description
Syntax                                                                      
Arguments
Example                                                                                
AddDays
Adds the specified number of days to a date. You may want to use this function to define a calculation data item.
AddDays(date,numDays)
date: A date.
numDays: Number of days to add.
AddDays("5/1/2000", 10)
AddHours
Adds the specified number of hours to a date. You may want to use this function to define a calculation data item.
AddHours(dateTime,numHours)
dateTime: A date with a time.
numHours: Number of hours to add.
AddHours("01/01/2011" "01:15", 3)
AddMinutes
Adds the specified number of minutes to a date. You may want to use this function to define a calculation data item.
AddMinutes(dateTime,numMinutes)
dateTime: A date with a time.
numMinutes: Number of minutes to add.
AddMinutes("01/01/2011" "01:15", 45)
AddMonths
Adds the specified number of months to a date. You may want to use this function to define a calculation data item.
AddMonths(date,numMonths)
date: A date
numMonths: Number of months to add.
AddMonths("01/01/2011", 9)
BuildDate Returns a date from the specified year, month, and day.
 
Note: This function does not require a month and day, but if you do not insert a value for these arguments, they will default to 1.
BuildDate(Numeric year, Numeric month, Numeric day) Numeric year: An integer for a year.
Numeric month: An integer for a month.
Numeric day: An integer for a day.
BuildDate(2010, 12, 3)
Now             Returns the current Date and Time in the local time zone, as of the start rule processing. Now() Current date and time in the local time zone are set by default Now()

  
  

Related Topics
Comparison Functions
String Functions
Math Functions
Bluespring-Specific Functions


Source
BPM Designer Topics > Common Expression Functions
Last modified at 7/31/2020 11:27 AM