Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi..
How to get days from weekend?
I used expression as
=Day(WeekEnd(CalendarDate))
But it's not working
try this
WeekDay() function like this
WeekDay(WeekEnd(CalendarDate)) as day2,
or
date(WeekEnd(CalendarDate),'www') as day1,
try this one
date(WeekEnd(TempDate),'WWWWW') as CalendarWeekEnd
or
date(WeekEnd(TempDate),'WWW') as CalendarWeekEnd