The StringToDate function converts a string value to a datetime object. Some use cases could include if your date is improperly stored as a string in your data extension and you want to convert it to a proper datetime format.
Syntax:
StringToDate(1,2)
1 = String value (can be a variable)
2 = Character set for encoding. Defaults to UTF-8 but can use UTF-16
Example:
%%[
var @string
set @string = “2021-01-13 09:00 PM”
]%%
%%=StringToDate(@string)=%%
Output:
1/13/2021 9:00:00 PM
Explanation:
In the AMPscript above, first we are declaring the variables using the var
function. Then defining the @string
variable as the string: “2021-01-13 09:00 PM”
The output of that value returned in datetime object as 1/13/2021 9:00:00 PM