Extract weekend days from date

[capriconuser]

hi all 

i have this date field and from that to extract only sat and sun.. which is weekend.. how i extract weekend from date.. 

data link 

https://www.dropbox.com/s/xaps82qyyo6i0fa/ar.xlsx?dl=0

[jaibau1993]

Hi!

If you want to keep only weekend days, then write something like

Load

        [Fields]

from [Excel]

where WeekDay(AttendanceDay) >= 5

Regards,

Jaime.

[Victor_Alumanah]

=Sum({<AttendanceDay = {'Sat','Sun'}>}WorkingHours)

[capriconuser]

there is only  dates in date field .. have you checked sheet ? 

@Victor_Alumanah 

[jaibau1993]

Hi

If you need it in an expression the use

Sum({<AttendanceDay = {"=WeekDay(AttendanceDay)>=5"}>}WorkingHours)

(i thought you needed it in script side)

Regards,

Jaime.

[Victor_Alumanah]

Sorry I seemed to have only pasted in part of the solution I had and now I can not seem to find where I saved it, the solution @jaibau1993 will give you Sat and Sun.