For new profile implementations, please use function "create date strict(adjustable template)" instead.
This fucntion returns a timestamp based on the value in a and the adjustable format template b. If in the error case the value cannot be parsed, the result of the function is the current date with set Empty Flag. If a already has the data type "Timestamp" or "Date", a conversion is not necessary. In this case, parameter b has to remain empty.
Parameters
Parameter | Description |
|---|---|
a | Text to be interpreted. If the text cannot be interpreted, the function returns the current date with set Empty Flag. Note: If an actual "Date" or "Timestamp" object is specified here instead of a text, parameter b has to remain empty. |
b | The date format template. Important note: If the string in a is shorter than the template in b, b is shortened to the length of a. Please note that in rare cases this can lead to loss of accuracy or invalid values and consequential errors. Special case W3CDTF: This format template does not consist of placeholders. Therefore, no shortening is done. |
Examples
Current date of this example: "2011-10-20 15:33:23.0".
Parameter a | Parameter b | Result |
|---|---|---|
241205 | ddMMyyHHmm | 2005-12-24 00:00:00.0 |
No date | ddMMyyHHmm | 2011-10-20 15:33:23.0 |
2412050820 | ddMMyyHHmm | 2005-12-24 08:20:00.0 |
1997-07-16T19:20:30Z (see format template W3CDTF) | W3C | 1997-07-16 21:20:30.0 |