User Guide

10.5.0
- 10.5.3
- 10.4.0
- 10.2.3
- 10.2.2 HotFix 1
- 10.2.2
- 10.2.1
- 10.2

Back Next

Dates, Times and Timestamps

Variables can be initialized to the current date, time or timestamp within a Project. These variables can then be used as attributes within tasks in Projects. Listed below are some examples on where these date/time/timestamp variables could be utilized within a Project:

To suffix the names of any files sent to a FTP server with a timestamp, so each file name is unique on the server.

To prefix the names of any daily files retrieved from a SFTP server with the current date, so existing files will not be overwritten on your system.

When inserting records into a database, to populate one of the columns (fields) with the current time.

A “Timestamp” task is provided in

Managed File Transfer

, which must be executed to initialize the date/time/timestamp variables. This Timestamp task needs to be placed in a Project above any tasks that need to utilize those variables.

The date/time/timestamp variables are only as current as the last time the Timestamp task was executed.

Project Designer Features

Example

Adding or Subtracting units from a Date, Time or Timestamp

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal