Example
In this example, we will pass a date-time offset value to the function transformation object using a Variables object.
Where,
dateTime = 01/03/2024 10:23:40 AM
In the output window, you can see that the provided date-time value has been returned with the time-offset part reset to 12:00:00 AM.
Name
DatePart with Offset
Syntax
DatePart (DateTimeWithOffset dateTime)
Purpose
To remove the time-offset part from the given date and returns date with time reset to 12:00:00 AM.
Description
Returns truncated date-time value after removing the given time-offset part.
Return Type
Date
Parameter
dateTime [System.DateTimeOffset] – date from which the time-offset part will be stripped