Custom Date Formatting
Format Strings
If you want to use the most general formatting block, you have to understand how to use format strings. They're used to specify the format of the resulting text and they're built from format specifiers.
Custom Date Formatting
Use the format as block to create your own, specific format. In the format-part you enter the date you want to extract data from. In the as-part you attach a textbox to it and enter the desired format structure:
The list of the most important date format specifiers:
| Format specifier | Description | Example |
|---|---|---|
| "d" | The day of the month, from 1 to 31. | 2021-06-01 13:45:30 -> 1 |
| "dd" | The day of the month, from 01 to 31. | 2021-06-01 13:45:30 -> 01 |
| "ddd" | The abbreviated name of the day of the week. Language-dependent, meaning the result in case of Wednesday is "Wed" if the device on which the iCL Filler is running, is using English language settings, "Mit" if the device language is German. | 2021-06-01 13:45:30 -> Tue |
| "dddd" | The full name of the day of the week. Language-dependent, meaning the result depends on the device language. | 2021-06-01 13:45:30 -> Tuesday |
| "h" | The hour, using a 12-hour clock from 1 to 12. | 2021-06-01 13:45:30 -> 1 |
| "hh" | The hour, using a 12-hour clock from 01 to 12. | 2021-06-01 13:45:30 -> 01 |
| "H" | The hour, using a 24-hour clock from 0 to 23. | 2021-06-01 13:45:30 -> 13 |
| "HH" | The hour, using a 24-hour clock from 00 to 23. | 2021-06-01 13:45:30 -> 13 |
| "m" | The minute, from 0 through 59. | 2021-06-01 13:45:30 -> 45 |
| "mm" | The minute, from 00 through 59. | 2021-06-01 13:45:30 -> 45 |
| "M" | The month, from 1 through 12. | 2021-06-01 13:45:30 -> 6 |
| "MM" | The month, from 01 through 12. | 2021-06-01 13:45:30 -> 06 |
| "MMM" | The abbreviated name of the month. Language-dependent, meaning the result depends on the device language. | 2021-06-01 13:45:30 -> Jun |
| "MMMM" | The full name of the month. Language-dependent, meaning the result depends on the device language. | 2021-06-01 13:45:30 -> June |
| "s" | The second, from 0 through 59. | 2021-06-01 13:45:30 -> 30 |
| "ss" | The second, from 00 through 59. | 2021-06-01 13:45:30 -> 30 |
| "tt" | The AM/PM designator. | 2021-06-01 13:45:30 -> PM |
| "yy" | The last two characters of the year, from 00 through 99. | 2021-06-01 13:45:30 -> 21 |
| "yyyy" | The year as a four-digit number. | 2021-06-01 13:45:30 -> 2021 |
You can find the full list of date format specifiers here.
Custom Time Formatting
The list of the most important time format specifiers:
| Format specifier | Description | Example |
|---|---|---|
| "h" | The hour, using a 24-hour clock from 0 to 23. | 09:45:30 -> 9 |
| "hh" | The hour, using a 24-hour clock from 00 to 23. | 09:45:30 -> 09 |
| "m" | The minute, from 0 through 59. | 09:45:30 -> 45 |
| "mm" | The minute, from 00 through 59. | 09:45:30 -> 45 |
| "s" | The second, from 0 through 59. | 09:45:30 -> 30 |
| "ss" | The second, from 00 through 59. | 09:45:30 -> 30 |
| "f" | The tenths of a second in a time interval. | 09:45:30.895 -> 8 |
| "ff" | The hundredths of a second in a time interval. | 09:45:30.895 -> 89 |
| "fff" | The milliseconds in a time interval. | 09:45:30.895 -> 895 |
You can find the full list of time format specifiers here.
Custom Numeric Formatting
The list of the most important numeric format specifiers:
| Format specifier | Description | Example |
|---|---|---|
| "0" | Zero placeholder: Replaces the zero with the corresponding digit if one is present; otherwise, zero appears in the result string. | 1234.5678 00000 -> 01235 |
| "#" | Digit placeholder: Replaces the "#" symbol with the corresponding digit if one is present; otherwise, no digit appears in the result string. | 1234.5678 ##### -> 1235 |
| "D" | Decimal: Returns the integer digits with optional negative sign. | -1234 D -> -1234 |
| "D1"/"D2"/"D3"/etc. | The number after "D" is the precision specifier: it specifies the minimum number of digits. "D3" is equal to "000". | 1234 D5 -> 01234 |
| "F" | Fixed-point: Returns the integer and decimal digits with optional negative sign with two decimal digits. | -1234.567 F -> -1234.57 |
| "F1"/"F2"/"F3"/etc. | The number after "F" is the precision specifier: it specifies the number of the decimal digits. | 1234.567 F5 -> 1234.56700 |
| "P" | Precent: returns the number multiplied by 100 and displayed with a precent symbol. | 1 P -> 100.00 % |
You can find the full list of numeric format specifiers here.