DatePart (DateTimeOffset)

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

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.