GetDateComponents (DateWithOffset)

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.

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.