syntax:functions:detectformat
Table of Contents
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/detectformat.txt · Last modified: 2023/11/24 20:55 by craigt