Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference CURRENTDATE
Functions and Expressions Reference Guide
80
CURRENTDATE
The CURRENTDATE function returns the current system date.
Syntax
CURRENTDATE ( )
Note Although CURRENTDATE has no arguments, it does require parentheses.
Meaning
CURRENTDATE ( )
Returns
This function returns a single-date.
Returns the system date. If being assigned to a date/time output item, the
current date is returned in the format specified by that output item. Otherwise,
the system date is returned in an MM/DD/YY presentation.
Example
StartDate = CURRENTDATE ( )
In this example, StartDate is assigned the value of the current dateIn this
example, because
CURRENTDATE is assigned to an output, it is automatically
converted to the presentation of StartDate. If
CURRENTDATE evaluates to
06/24/37 and StartDate has a YYMMDD presentation, the result is 370624.
FROMDATETIME ( CURRENTDATE ( ) , "DD.MON.CCYY" )
In this example, the current date is returned in DD.MON.CCYY format. If
today’s date is January 5, 1999, the date returned would be 05.JAN.1999.
Uses
Use
CURRENTDATE when you need the current date as a transaction processing
date, an order received date, or other date that reflects when the data was
mapped.
When you need to parse the system date, use
CURRENTDATE with the TEXT or
FROMDATETIME functions.
Related Functions
CURRENTDATETIME, CURRENTTIME, FROMDATETIME, DATETOTEXT