SET_DAY Function
Description: Set the day of the month for the date provided. This function is only valid for data elements with a processing type of date.
Parameters: String, Integer
- Source date: The string containing the source date value.
- New day: Sets the day to this value.
Return: String containing the updated date.
Syntax: SET_DAY(<source date>,<new day>)
Example: Set the day of month to 01 for all birth dates.
DE("Birth Date").setValue
( SET_DAY( DE("Birth Date").getOriginalValue( ), 1) );
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*