DATE2STR Function

Description: This function converts Data Privacy's internal date format to a string containing the date in the format specified by the user so that processing can operate against the data based on having a specific data format. Use this function to convert a date data element value before searching a translate table for matching data.

Parameters: String, String

  • Source date: The string containing a date in Data Privacy's internal format.
  • Format: The string containing the date format of the output data.

Return: A string containing the date in the format specified.

Syntax: DATE2STR (<source date>,<format>)

Important

If you need to create a date format requiring additional Java date pattern letters, refer to your Java documentation for more information.

Example: Convert Data Privacy's internal format to ddMMyyyy source date.

DATE2STR ( DE( "DATE DE" ).getOriginalValue( ),"ddMMyyyy");

{{export-indexterm primary="DATE2STR function"/}}

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*