====== DetectFormat(text_date) ====== Category: Date and Time function \\ =====Description===== This function detects the date-time format of the text date (or timestamp) provided as the argument ("text_date"). \\ =====Arguments===== ^Argument^Type^Description^ |text_date|Text|Text value representing a date or timestamp.| **Return value type:** Text \\ =====Remarks===== If the format of the //text_date// argument cannot be detected, an "Ambiguous format" error is returned. \\ =====Examples===== detectformat("2023-Nov-4") //Returns "yyyy-MMM-d" detectforamt("11/4/2023") //Returns error "Ambiguous format" \\ =====See also===== * [[syntax:functions:format|Format(date_as_number,format)]] * [[syntax:functions:istextdate|IsTextDate(text_date)]]