Automation Engine Script Guide > Ordered by Function > Date and Time > ADD_PERIOD

ADD_PERIOD

Script Function: Adds a period to a specified date.

Syntax

ADD_PERIOD(Date, Period Format:Period, [Output Format])

Syntax

Description/Format

Date

Indication of a date in the format "YYMMDD" or "YYYYMMDD".

Format: script literal or script variable

It is also possible to specify a different date format. Do so by entering the required date format, then enter a separator (: or ;) and afterwards the date. Indicating a date format is optional.

Period Format:Period

Format: scriptA particular Automation Engine object type. literal or script variableA placeholder for a value within a script.

Period: Entry of a period to be added to specified date.
Period Format: Format guidelines for the Period.

As a separator between the Period Format and the Period you can either use a colon (:) or a semi colon (;).

Output Format

Format guidelines for the determined date.
Format: AE name, script literal or script variable
Default value: "YYMMDD" 


Return code

Date in the specified format.

Comments

This script functionPre-defined run book template in the Automation Engine. One single step only, e.g. Start Windows Service, Copy file,… adds years, months, quarters or weeks to a specified date.

This function is given a date. Optionally, you can specify a date format. The default date format to be used if nothing has been specified is either "YYMMDD" or "YYYYMMDD".Use a colon or semicolon as separator between Date Format and Date.

The Period is added to the specified Date. Period can be any number. An error will occur if the result dates later than 12/31/9999.

Output Format is optional. If it has not been specified, the script function returns the date in the default format "YYMMDD".

Examples

The first example adds two weeks to 03/6/2000. The result (20.03.2000) is output to the reportA report provides more detailed information about a task's execution or a component..

:SET &DATE#=ADD_PERIOD ("DD.MM.YY:06.03.00","WW;2","DD.MM.YYYY")
:
PRINT &DATE#

The second example adds a quarter to 01/31/2000. The result (30-04-2000) is output to the report.

:SET &DATE#=ADD_PERIOD ("000131","Q:1","DD-MM-YYYY")
:
PRINT &DATE#

In the third example, a year is added to the date 02/29/2000. The result of 29.2.2001 is output to the report because the year 2001 is not a leap year.

:SET &DATE#=ADD_PERIOD ("20000229","YY:0001",DD.MM.YYYY)
:
PRINT &DATE#

 

See also:

Script Elements - Date and Time

Date, Time and Period Formats

About Scripts
Script Element - Alphabetical Listing

Script Element - Listed by Function

 


Automic Documentation - Tutorials - Automic Blog - Resources - Training & Services - Automic YouTube Channel - Download Center - Support

Copyright © 2016 Automic Software GmbH