DATEVALUE function

This topic describes the formula syntax and usage of the DATEVALUE function in the Data Quality Execute Formula transform.

Description

Converts a date in the form of text to a serial number. This function is useful to convert dates to a format that can be sorted, formatted, or used in date calculations.

To view a date serial number as a date, you must apply the date format to the output column.

Syntax

DATEVALUE(date_text)

The DATEVALUE function syntax has the following argument:

date_text Required Reference to a column that contains dates in date format.