# GetDateComponents (DateWithOffset)

| **Name**    | ***GetDateComponents***                                                         |
| ----------- | ------------------------------------------------------------------------------- |
| Syntax      | GetDateComponents (DateTimeWithOffset dateTime)                                 |
| Purpose     | To return a structure providing individual date components.                     |
| Description | Gets a structure representing individual date components.                       |
| Return Type | DateComponents                                                                  |
| Parameters  | dateTime \[System.DateTimeOffset] – Date time for which components are required |

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2Fedvm5PLj7N5k8kLMnmsx%2F0.png?alt=media)

**Example**

We have an *Orders* dataset with the *OrderDate* field.

In this example, we will pass this field to the function transformation object to get the date components.

<figure><img src="https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FooEk73gsR4ykfxr2neov%2F1.png?alt=media" alt=""><figcaption></figcaption></figure>

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FLeKuGfpNlb44LOvfRe4K%2F2.png?alt=media)

**Note:** The *GetDateComponents (DateTimeWithOffset dateTime)* function differs from the *GetDateComponents(Date dateTime)* function as it includes a Timezone Offset value. The Offset value is the number of hours or minutes a time zone is ahead of or behind GMT (Greenwich Mean Time).

Right-click on the function transformation object and select *Preview Output.* In the output, you can see that each date from the *OrderDate* field has been separated in the different date components.

<figure><img src="https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2Fr7iqZhBACxLDXiw7K8ii%2F3.png?alt=media" alt=""><figcaption></figcaption></figure>
