how to find the weekend dates from given list of dates

179 Views Asked by At

I have a list of dates and other columns in which have to find the weekend dates among them and the the weekend dates should be there in the list of given dates

enter image description here

Output should be some thing like this...

enter image description here

Any help is appricated thanks.

1

There are 1 best solutions below

6
On

use datepart (dw,.. to filter data needed