IsTextDate(text_date)

Category: Date and Time function

This function determines if the argument ("text_date") is a recognizable text date and returns TRUE if so.

Return value type: TRUE/FALSE

istextdate("2023-Nov-4")  //Returns TRUE

istextdate("11/4/2023")  //Returns TRUE (although in an ambiguous format)

• DetectFormat(text_date)
• Format(date_as_number,format)