# Data types and formatting

Coupler.io allows user to work with different data types, so you can represent your data appropriately using specified format and use proper filtering / sorting options.&#x20;

### String

String data type stands for alphanumeric characters.

*Examples:*

* `this is a string value`
* `string`
* `123text`
* `Hello!`

<div align="left"><figure><img src="https://2487187314-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FCgnmco7kCnvytNIN8YdT%2Fuploads%2FPfU8O0VMudQ4UJw6TU9u%2Fimage.png?alt=media&#x26;token=fb2792f1-a147-4461-9963-29642f3388fb" alt="" width="563"><figcaption></figcaption></figure></div>

### Number <a href="#number" id="number"></a>

Number data type stands for numeric values. Coupler.io supports different data types and formats along with precision described below.

{% tabs %}
{% tab title="Integer" %}
Whole numbers.

*Examples:*

* `0`
* `-1`
* `99999999`&#x20;

<div align="left"><figure><img src="https://2487187314-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FCgnmco7kCnvytNIN8YdT%2Fuploads%2FCV3jakDq6K4G6Xl4lPAW%2Fimage.png?alt=media&#x26;token=24f0db2f-ed04-4b76-86d9-63ce1b0aa5a6" alt="" width="375"><figcaption></figcaption></figure></div>
{% endtab %}

{% tab title="Decimal" %}
Numbers with a decimal point.

*Examples:*

* `0.1`
* `-0.1243`
* `11.78`

<div align="left"><figure><img src="https://2487187314-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FCgnmco7kCnvytNIN8YdT%2Fuploads%2FlnwZv8lghioGjfvacbvu%2Fimage.png?alt=media&#x26;token=f11d3b46-455a-4869-b637-d62672025612" alt="" width="375"><figcaption></figcaption></figure></div>
{% endtab %}

{% tab title="Decimal with precision" %}
Number of digits after decimal point.

*Examples:*

* precision `1.0`: 12.3
* precision `1.00:` 22.74
* precision `1.000000:` 0.851789

<div align="left"><figure><img src="https://2487187314-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FCgnmco7kCnvytNIN8YdT%2Fuploads%2FzR8j3pMg8GCaUEYVInhL%2Fimage.png?alt=media&#x26;token=1a352303-7964-415e-b36a-90e2578a53ee" alt="" width="375"><figcaption></figcaption></figure></div>
{% endtab %}

{% tab title="Percent" %}
Percent representation of a numerical value. Can be used with precision

*Examples:*

* `0.2%`
* `99%`
* `-11%`

<div align="left"><figure><img src="https://2487187314-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FCgnmco7kCnvytNIN8YdT%2Fuploads%2F5MPMPkpgg6P9JGkYHHHT%2Fimage.png?alt=media&#x26;token=3fbcb6cc-06a1-424c-8a86-e0c04aee2d7c" alt="" width="375"><figcaption></figcaption></figure></div>
{% endtab %}

{% tab title="Currency" %}
Currency representation of a numerical value. Can be used with precision

*Examples:*

* `$10`
* `UAH 12`
* `£2`

<div align="left"><figure><img src="https://2487187314-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FCgnmco7kCnvytNIN8YdT%2Fuploads%2F0fq871aPVopvN9z8kVBW%2Fimage.png?alt=media&#x26;token=12b0690e-9794-4801-bcf6-e3f6afe2067c" alt="" width="375"><figcaption></figcaption></figure></div>
{% endtab %}
{% endtabs %}

### Date and DateTime <a href="#date" id="date"></a>

Stands for date or datetime values.&#x20;

Make sure that you have in the source needed columns in 'Date' or 'DateTime' **ISO format** (e.g. YYYY-MM-DD, YYYY-MM-DD HH:mm).

{% tabs %}
{% tab title="Date" %}
*Examples*

* `2017-05-06`
* `1987-02-27`&#x20;

<div align="left"><figure><img src="https://2487187314-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FCgnmco7kCnvytNIN8YdT%2Fuploads%2FJvzwO7z3WiEPgNuBgOVB%2Fimage.png?alt=media&#x26;token=081ce8e5-98db-4ff3-945a-c432507738cf" alt="" width="375"><figcaption></figcaption></figure></div>
{% endtab %}

{% tab title="DateTime" %}
*Examples:*

* `2023-07-11T14:10:33.682Z`
* `2023-07-11T13:20:38.489Z`&#x20;

<div align="left"><figure><img src="https://2487187314-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FCgnmco7kCnvytNIN8YdT%2Fuploads%2FmbxSZEO1zXWqC6iSSKBd%2Fimage.png?alt=media&#x26;token=d578de25-c143-453b-8cf9-c7a99b57422a" alt="" width="375"><figcaption></figcaption></figure></div>
{% endtab %}

{% tab title="Time Zone" %}
When dealing with Date or DateTime types, you would even have the option to specify which Time Zone to follow:

<div align="left"><figure><img src="https://2487187314-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FCgnmco7kCnvytNIN8YdT%2Fuploads%2FRMMYPfKgG26XzyzfDEQk%2Fimage.png?alt=media&#x26;token=74611d08-914a-40ef-b09d-7eb8e7d93c21" alt="" width="375"><figcaption></figcaption></figure></div>
{% endtab %}
{% endtabs %}

### Boolean <a href="#boolean" id="boolean"></a>

Boolean type that has one of two possible logical values: true or false.

**Examples:**

* `TRUE`
* `false`
* `0`
* `t`

<div align="left"><figure><img src="https://2487187314-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FCgnmco7kCnvytNIN8YdT%2Fuploads%2FLAnrM8iKbJWrX6rUJDjq%2Fimage.png?alt=media&#x26;token=5d094bf3-aa81-40cd-bdaf-2d9f4cb331ae" alt="" width="375"><figcaption></figcaption></figure></div>
