StringToDate()
Converts a date string to a .NET datetime object.
The StringToDate() function has one parameter:
dateString(string): Required. The date or timestamp to convert to a .NET datetime object.
You can specify a date string in several formats, including:
- ISO 8601 timestamp:
2023-08-05T13:41:23-06:00 - ISO 8601 date:
2023-08-05 - US date and time notation:
8/5/2023 1:41 PM - Long-form notation:
5 August 2023orAugust 5, 2023 - Date and time:
2023-08-05 1:41:23 PM - Time only:
1:41 PM - Chinese and Japanese notation:
2023 年 8 月 5 日 - Korean notation:
2023년 8월 5일
The function doesn’t support these formats:
- Dates in which the day includes an ordinal suffix, such as
August 5th, 2023or5th August 2023. - Little-endian numeral notation, such as
5/8/2023to represent the 5th of August, 2023. - Month names in languages other than English, such as
5 août 2023. - Dates that include any numerals other than Western Arabic numerals, such as
٢٠٢٣/٨/٥. - Dates based on any calendar system other than the Gregorian calendar, such as
18 Av, 5783or18 Muharram, 1445.
To use this function, pass it a date or timestamp in a supported format.
The example returns the timestamp as a .NET datetime object.