PATCH A SharePoint Date Column In Power Apps

Goal

Change the VacationDate column (Date Type) from 11/7/2020 to 12/25/2020.

Input

Vacation Requests (SharePoint List)

ID	EmployeeName	VacationDate	Hours
1	Matthew Devaney	11/7/2020	8

Patch Function Code

Patch(
    'Vacation Requests',
    LookUp('Vacation Requests', ID=1),
    {
        VacationDate: Date(2020,12,25) 
    }
)

Output

Vacation Requests (SharePoint List)

ID	EmployeeName	VacationDate	Hours
1	Matthew Devaney	12/25/2020	8

Scenario #1: Date Picker

Patch a value found in a date picker to a Date field.

Patch Function Code

Patch(
    'Vacation Requests',
    LookUp('Vacation Requests', ID=1),
    {
        VacationDate: DatePicker_VacationDate.SelectedDate 
    }
)