This function extracts a certain date from a given date.
Parameters:
- Expression. Type: Date.
- Period type. A string containing one of the following values:
- Minute
- Hour
- Day
- Week
- Month
- Quarter
- Year
- TenDays
- HalfYear
ENDOFPERIOD(DATETIME(2009, 10, 12, 10, 15, 34), "Week")
Result:
10/13/2009 11:59:59 PM
Next page: DATEADD
