Increases the year portion of a dtl value by a specified number.
Usage
ADDYEAR(date,numberOfYears)
Parameters
Returns
A copy of the dtl argument, with the integer argument added to the year portion.
dtl
Remarks
Sample
addYearSample.fls.xml... <textview label="Your next dental checkup is due on " text='{FORMATDTL((ADDYEAR(sysp.dtlFormOpen, 1)), (dtf yyyy"-"MM"-"dd" "HH":"mm":"ss))}'/> ...
addYearSample.fls.xml
... <textview label="Your next dental checkup is due on " text='{FORMATDTL((ADDYEAR(sysp.dtlFormOpen, 1)), (dtf yyyy"-"MM"-"dd" "HH":"mm":"ss))}'/> ...
ADDYEAR(sysp.dtlFormOpen, 1
Figure 290. This textview displays the date exactly one year from the current date
textview
Related links
Search Highlighter (On/Off)