Category: Date and Time function
This function detects the date-time format of the text date (or timestamp) provided as the argument ("text_date").
Argument | Type | Description |
---|---|---|
text_date | Text | Text value representing a date or timestamp. |
Return value type: Text
If the format of the text_date argument cannot be detected, an "Ambiguous format" error is returned.
detectformat("2023-Nov-4") //Returns "yyyy-MMM-d"
detectforamt("11/4/2023") //Returns error "Ambiguous format"