Product: LABELVIEW, CODESOFT
Version: All Versions
|
1. If you haven't already done so, go to View and enable the Data Sources panel.
2. Right-click Formula and select Add. This will launch the Formula window.
3. From the Formula tab, give the formula a Name.
4. Select the Date & Time category from the list of predefined formulas, and then select DateOffset. Click Insert.
5. The DateOffset formula will appear in the text box. This formula needs four pieces of information: date, offset, offsetUnit, and changeMonth.
a. date sets the base date value.
b. offset is the number of units to be added to the base date.
c. offsetUnit is the interval to offset the date, where "d" = day, "m" = month, and "y" = year.
d. changeMonth sets whether the date changes to the next month if the calculated date doesn't exist in the current month, where 0 = no and 1 = yes.
6. Input your shift data into the DateOffset formula. Verify that the preview displays the offset date. Click OK
7. Place the formula on the label, either by clicking and dragging the formula from the Data sources window, or by right-clicking the formula and selecting Place.
|