Preface
Informatica Managed File Transfer Welcome Overview
- Managed File Transfer General Features
  - Workflow Automation
  - Ad-Hoc File Transfers and Collaboration
- Getting Started
  - Screen Tips
  - Login
Dashboard
Resources
Workflows
Task Reference
Services Overview
Users
Logs and Reports
Encryption
System
Appendix
Glossary Terms
- AES
- Asymmetric
- Asymmetric Cryptology
- Authentication
- Certificate
- Certificate Authority
- CIDR
- Cipher
- Cryptology
- CSV
- Decryption
- Diffie-Hellman/DSS
- Digital Signature
- DSA
- Element
- Encryption
- Fingerprint
- FTP
- FTPS
- Hash Function
- HTTP
- HTTPS
- ICAP
- Icon
- ISO format
- JCE Service Provider
- JDBC drivers
- JKS
- Key
- Key Alias/Key ID
- Key Pair
- Key Store
- MDN
- MMS
- Non-Repudiation
- Passphrase
- PKCS12
- Private Key
- Project
- Public Key
- Public Key Cryptology
- Public Keyring
- RSA
- Run Priority
- SAML
- Secret Key
- Secret Keyring
- Self-Signed Certificate
- SFTP
- Signing
- SMS
- SMTP
- SSH
- SSL
- SSO
- Symmetric
- Symmetric Cryptology
- URL
- Variable
- Verification
- XML

User Guide

10.2.2 HotFix 1
- 10.5.3
- 10.5.0
- 10.4.0
- 10.2.3
- 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