Hi All i have a requirement that i need to calculate the working days between two any given sundays. Attached is the QVW file which will have _FlagWorkingDay column if _FlagWorkingDay=0 then its not a working day and if _FlagWorkingDay=1 then it is a working day. Now i want the output like this in my final table should look like i need dates related to sundays and working days related to that sunday. Please let me know in case of any questions. i am attaching the QVW file.
Re: Calculate Number of working days between Sundays
HI Mark, Thank you for your response. Actually i want that calculation need to perform in the script. Here is the challenge i don't have date range i can mention because i will always have 2 to 3 years of data. Another challenge is My working days does not depend on weekdays ( Monday- Friday). Its based on our warehouse working days and that working days will be determined by _FlagWorkingDay. Thanks for your help in advance.