Contact Us 1-800-596-4880

Generate and Modify Date and Time

Use Generate date and time to create a configurable timestamp. Select a country-specific style for the timestamp from the selection of format templates or arrange the available time components as required, e.g. day, month, and hour. You can specify the timestamp as a specific time in the future or past, or use the current system time. It is also possible to incorporate a time offset in days, hours, minutes, and seconds. Generate date and time creates a timestamp that is available in several variables, which you can further process in other action steps.

Properties

  • Generate Date and Time Settings

    Generate date and time incorporates the specified values into the calculation of the selected time stamp (time offset). This action step supports positive and negative numbers. The default value is 0 in each case.

  • Calendar week setting

    Specify either Monday or Sunday as the starting day for the week.

  • Days to Add

    Number of days to add.

  • Generate day and time mode

    Select whether to use the Current system date and time, Custom date and time, or Generated date and time from given variables. The time offsets from the Years to add, Months to add, Weeks to add, Days to add, Hours to add, Minutes to add, Seconds to add fields apply for the calculation in all cases.

  • Hours to add

    Number of hours to add.

  • Minutes to add

    Number of minutes to add.

  • Months to add

    Number of months to add.

  • Output language culture (for the day of the week)

    Specify the output language to use for the days of the week.

  • Override activated

    Enables overriding workday settings.

  • Override to day

    Specify the day to override with.

  • Override to first or last

    Specify either the first or last day of the given period (for example, last day of the month).

  • Seconds to add

    Number of seconds to add.

  • Start workday of week

    Specify the starting workday of the week.

  • Weeks to add

    Number of weeks to add.

  • Workdays setting

    Select between a five-day or six-day workweek.

  • Years to add

    Number of years to add.

Variables

The following variables relate to the configurable timestamp generated after applying any time offset. Generate date and time outputs the Formatted variable in the specified DateTime format and the other variables in accordance with the date format settings specified in the operating system.

  • Formatted

    The Generate date and time.Formatted variable provides the timestamp using the date and time format selected.

  • Date

    The Generate date and time.Date variable provides the date.

  • Time

    The Generate date and time.Time variable provides the time.

  • Year

    The Generate date and time.Year variable provides the year.

  • Month

    The Generate date and time.Month variable provides the month as a decimal number.

  • Day

    The Generate date and time.Day variable provides the day as a decimal number.

  • Hour

    The Generate date and time.Hour variable provides the number of hours.

  • Minute

    The Generate date and time.Minute variable provides the number of minutes.

  • Second

    The Generate date and time.Second variable provides the number of seconds.

Wizard

The Wizard enables you to generate a timestamp based on the specified time variables, select the starting day of the week, and specify the output format and language.

  • DateTime settings

    Enables you to specify the date to generate.

    Select a Generation mode and specify the time variables to generate the desired date output. The available generation modes are:

    • Current system date and time: Uses the current system time as the timestamp.

    • Custom date and time: Uses the time selected in the DateTime field as the timestamp.

    • Generated date and time from given variables: Calculates the timestamp using the specified values.

  • Workday settings

    Enables you to specify a given day of the month by following some rules.

    Select Override date to and use the dropdown options to specify a day in the month to use.

  • Calendar settings

    Enables you to select the starting day of the week between Monday and Sunday.

  • Output settings

    Enables you to select the Output format and the Output language for the day of the week.