This project has moved. For the latest updates, please go here.

Date conversion

Summary

This transform allows manipulation of date time data. Incoming values can be converted from one format to another, have units added or subtracted from them, and moved between time zones.

Parameters

Parameter Description
Input type Specifies the type of the input data. See the supported types section below.
Input format When a custom string format is specified as the input type, this defines the string format of the date
Input time zone Specifies what time zone the input date is in
Calculation type Specifies the type of calculation to make on the date. Valid options are add, subtract, or no calculation
Calculation amount When performing a date calculation, this is the number of units to add or subtract
Calculation units When performing a date calculation, specifies the type of units to add or subtract in the quantity specified by Calcuation amount
Output type Specifies the type that should be returned by the transform. See the supported types section below
Output format When a custom string format is specified as the output type, this defines the string format of the date
Output time zone Specifies what time zone to output date should be returned as

Input Type

The transform accepts an integer, string, or DateTime as an input value, depending on the value of the input type parameter. The Support types table below details what ACMA data type is supported for each input type.

Multiple input values

The transform accepts multiple input values, and processes each of them individually

Return Type

The transform returns a data type that is determined by the Output type parameter

Supported types

Type ACMA data type Description
.NET ticks integer A 64-bit integer representing the number of 100-nanosecond intervals that have elapsed since 12:00:00 midnight, January 1, 0001.
FIM service date string string A FIM service compatible ISO8601 date string
Custom string format string Any .NET standard or custom string format
Native DateTime DateTime The built-in ACMA DateTime data type
File time Integer The Microsoft FileTime data type, most commonly used to store time stamps in Active Directory, which is a 64-bit value representing the number of 100-nanosecond intervals since January 1, 1601 (UTC)

Last edited Feb 22, 2015 at 1:12 AM by ryannewington, version 2