GetDateComponents (DateWithOffset)
Last updated
Last updated
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.