- ISDATE: This follows the syntax ISDATE(string). It returns TRUE if the string is a date otherwise, it returns FALSE, for example, ISDATE("24-05-2019")= TRUE.
- DATEPARSE: This follows the syntax DATEPARSE(format, string). It is used to convert a string into DATE in the format specified. For example, DATEPARSE("dd-MM-yyyy","24-05-2019) returns 24-05-2019 as a date.
- DATEADD: This follows the syntax DATEADD(date_part, interval, date). It adds the interval to date_part specified of the date. DATEADD is one of the most commonly used date functions.
Suppose there was an issue in the system and all of the order dates captured were wrong. They were actually a month before they are showing in the calculation. To get the right ...