Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have date from ist jan 2020 to 14 feb 2023 and i want to count date excluding first and second saturday of Month and all the sundays ? please help asap
in your master calendar add something like.
If(weekday(tmpDate)=6 or (weekday(tmpDate)=5 and day(tmpDate)<=14),1,0) as Exclude_Flag
in your master calendar add something like.
If(weekday(tmpDate)=6 or (weekday(tmpDate)=5 and day(tmpDate)<=14),1,0) as Exclude_Flag
Hi @ogster1974 thank you for your response from this i have got the answer .
i have done this in another way please review it if it's right
(Count({$<WeekDay={'Sat'},Day={'(<=14)'}>}Date)) + (Count({$<WeekDay={'Sun'}>}Date))
from this i am getting same output