Example
In this example, we will pass a date time value to the function transformation object using a Variables object.
Where,
dateTime = 7/13/2022 4:12:19 PM
In the output window, you can see that the provided datetime value has been returned with the time part reset to 12:00:00 AM.
Name
DatePart
Syntax
DatePart (Date dateTime)
Purpose
To remove the time part from the given date and returns date with time reset to 12:00:00.
Description
Returns truncated date value after removing the given time part.
Return Type
Date
Parameter
dateTime [System.DateTime] – date from which the time part will be stripped
