topic Re: How to identify whether it is Saturday or sunday from Date in App Development

How to identify whether it is Saturday or sunday from Date

P_Kale — Thu, 28 Dec 2023 11:47:45 GMT

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 — Thu, 28 Dec 2023 12:05:23 GMT

Weekday(), perhaps?

Anil_Babu_Samineni — Thu, 28 Dec 2023 12:05:48 GMT

Perhaps this?

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

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

P_Kale — Thu, 28 Dec 2023 12:12:53 GMT

Thanks it is working