Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi!
If you want to keep only weekend days, then write something like
Load
[Fields]
from [Excel]
where WeekDay(AttendanceDay) >= 5
Regards,
Jaime.
=Sum({<AttendanceDay = {'Sat','Sun'}>}WorkingHours)
there is only dates in date field .. have you checked sheet ?
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.
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.