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

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.