FORMATDATE
The FORMATDATE function formats the DateTime formatted input data to the specified string.
Input/Output
Number of Connections: 1
| Input | Data Type | Description |
| Input1 | DateTime | The time data. |
| Output | Data Type | Description |
| Output1 | String | The formatted input string as specified by the Format property. |
Property
| Name | Property Type | Description |
| Format | choice |
Specifies how to format the input DateTime data to a string.
You can specify the format directly except for pre-defined format. For details of format, please refer the following topic "Date and Time Patterns".
| yyyy/MM/dd HH:mm:ss | - | Example：2006/09/27 16:36:44
|
| yyyy/MM/dd hh:mm:ss | - | Example：2006/09/27 04:36:44
|
| yyyy/MM/dd | - | Example：2006/09/27
|
| ggggeeee年M月d日H時m分s秒 | - | Example：平成18年9月27日16時36分44秒
|
| ggggeeee年M月d日h時m分s秒 | - | Example：平成18年9月27日4時36分44秒
|
| ggggeeee年M月d日 | - | Example：平成18年9月27日
|
| geeee年M月d日H時m分s秒 | - | Example：H18年9月27日16時36分44秒
|
| geeee年M月d日h時m分s秒 | - | Example：H18年9月27日4時36分44秒
|
| geeee年M月d日 | - | Example：H18年9月27日
|
|
| TimeZone | choice | Specifies the time zone.
- System Timezone [(default)]
-
The system's default time zone is used.
- (GMT) [(GMT)]
-
Greenwich Mean Time is used.
|
| Locale | choice | Defines the locale.
| System Locale [(default)]
| - |
The system's default locale is used.
|
|
Topic
- For more details on the format syntax, please refer to the SimpleDateFormat class documentation.
It is described by combining the following letters.
| Symbol | Meaning | Meaning |
| g | Era name | Heisei |
| e | Year corresponding to era name | 18 |
| G | era designator | AD |
| y | year | 2003 |
| M | month in year | July and 07 |
| d | day in month | 10 |
| h | hour in am/pm (1-12) | 11 |
| H | hour in day (0-23) | 0 |
| m | minute in hour | 45 |
| s | second in minute | 54 |
| S | millisecond | 955 |
| E | day in week | Tuesday |
| D | day in year | 145 |
| F | day of week in month | 2 (2nd Wed in July) |
| w | week in year | 24 |
| W | week in month | 2 |
| a | am/pm marker | PM |
| k | hour in day (1-24) | 24 |
| K | hour in am/pm (0-11) | 0 |
| z | time zone | Pacific Standard Time |
| ' | escape for text |
|
| '' | single quote | ' |
- It becomes the era name of the alphabet one character when the number of pattern characters of the era name is one, it becomes the era name of the Chinese character one character in case of two, and it becomes the era name of the Chinese character two characters in case of three or more. For example, in the case of "平成", each output becomes "H", "平", and "平成"
- When the number of era name year's pattern characters is three or less, it becomes the number of minimum digits as usual, and it becomes one character of former ''for one year it and other ages become the numbers of minimum digits in which three is subtracted in case of four or more.
- Era name year's pattern character doesn't correspond to the Chinese numerals.
- When "z" is not used, it interprets it as a date in the time specified with TimeZone. When "z" is used, TimeZone is ignored.
- For more details on the format syntax, please refer to the SimpleDateFormat class documentation.
Example
| Property | Output |
| Input1 | 20020430T12:00:00 | Format | yyyy/MM/dd | 2002/04/30 |
| | TimeZone | America/New_York | |
| | Locale | US | |
| Property | Output |
| Input1 | 20020430T12:00:00 | Format | yy/M/d | 02/4/30 |
| | TimeZone | America/New_York | |
| | Locale | US | |
| Property | Output |
| Input 1 | 20020401T12:00:00 | Format | MMMMM dd, yyyy hh:mm aaa | April 01, 2002 12:00 PM |
| | TimeZone | America/New_York | |
| | Locale | US | |