how to get saturday and sunday dates

[Karim_Khan]

Hi Team,

    I have run the script for getting weekend but i am not getting saturday

WeekEnd(DATE) AS WEEKEND

[Anonymous · Accepted solution]

Hi Karim,

Try this: If(WeekDay(DATE) = 'Sat' or WeekDay(DATE) = 'Sun',DATE)

Regards!

[Anil_Babu_Samineni]

Do you mean you want to load only Saturday date?

[tresesco]

Try like:  

Weekday(WeekEnd(DATE)) AS WEEKEND    

If your week starts on Monday, it will return Sunday as output. If you need the week to start on Sunday and get Saturday as weekend output try:

Weekday(Weekend(today(),0,-1))   

[Karim_Khan]

tnx

[Karim_Khan]

I wanted both sat and sun

[Karim_Khan]

I wanted both sat and sun

[Anonymous]

You're wellcome!

[capriconuser]

@Karim_Khan  your solution extract only Saturdays .. i want to get also Sundays so what should i do 

[ajayvermaida]

Hi Anil,

I want to find the time difference only for saterday and sunday between two dates from 10 AM to 4 PM .

how can I do that .

for example if my startdate - 31-01-2020  and enddate = 5-2-2020 

I just want to pick Saterday and sunday between these two date and the time in between 10 AM to 4 PM .