CURRENTDATE

You can 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. The function returns the current system date.

Syntax:
CURRENTDATE ( )
Meaning:
CURRENTDATE ( )
Returns:
A single date

CURRENTDATE has no arguments but it does require parentheses.

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.

Examples

  • StartDate = CURRENTDATE ( )

    In this example, StartDate is assigned the value of the current date. In 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.

Related functions

  • CURRENTDATETIME
  • CURRENTTIME
  • FROMDATETIME
  • DATETOTEXT

Feedback