Skip to main content

Using Advanced Expressions: Add_[DatePart]

Distributor guide to ADD_DAYS, ADD_YEARS, ADD_MINUTES and other ADD_ expressions in Encompass Fusion reports: add or subtract time from a date. Needs FusionEdit permission and v23.01+.

B
Written by Bailey Naas-Thornton

Minimum Version Required: 23.01

Pre-Conditions

  • Required Permission - FusionEdit
    ​
    ​

  • Recommended Fusion I/II Certification

Steps

The ADD_ function adds seconds, minutes, days, weeks, months, or years to the selected value.
​
This function is similar to the DateAdd Function however, instead of defining the Date Part within the expression, Add_[DatePart] defines it within the function itself.


Syntax:

ADD_DAYS(Date/Time Value , Value To Add)

ADD_YEARS(Date/Time Value , Value To Add)

ADD_MINUTES(Date/Time Value , Value To Add)


Arguments

Date Value:

The Date to which you want to add to.


Value To Add:

The number of days/weeks/year/etc. to be added to the date. This can be a positive or negative number.

Did this answer your question?