STR2DATE Function

Description: This function convert a date in string format to Data Privacy's internal date format so date processing can operate against the data.

Parameters: String, String

  • Source date: The string containing the source date value.
  • Format: The string containing the format of the input data.

Return: A string containing the date formatted in Data Privacy's internal format.

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

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

STR2DATE( "19560312", “yyyyMMdd");

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

 

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