How to identify whether it is Saturday or sunday from Date

[P_Kale]

Hi,

I have various dates in data from those date how I will know whether that date belongs to Saturday or Sunday.

If it belongs to Saturday or Sunday then only in another column it should wright SAT or SUN depends on date. For e.g.

09/12/2023 then 'SAT'

10/12/2023 then 'SUN'

11/12/2023 then NULL etc.

[Or]

Weekday(), perhaps?

[Anil_Babu_Samineni · Accepted solution]

Perhaps this?

If(WeekDay(DateField)='Sat', 'Sat', 

     If(WeekDay(DateField)='Sun', 'Sun', 'Null'))

More info, weekday - script and chart function | Qlik Sense on Windows Help

[P_Kale]

Thanks it is working