Not including Fridays in Calendar Report?
Hey Everyone,
I'm obviously fairly new to QuickBase, I've managed to get my durations and dates converted to 'WorkDates' to include the Start Date and 'WeekDayAdd' so now my durations are "skipping" over the weekends. But I can't seem to figure out how to get accurate dates for a department working 4 - 10s! Is there something I can add for this department to ignore Fridays as well like WeekDayAdd does for weekends?? All my calculations and formulas are accurate up to this point to convert a number of hours into 10 hour days, then displaying days on a Calendar, but because Fridays are being included, this department will show it's due earlier then it actually is (Based on how many Fridays the duration passes through)...
Thanks,
------------------------------
Alex Bennett
------------------------------
I'm obviously fairly new to QuickBase, I've managed to get my durations and dates converted to 'WorkDates' to include the Start Date and 'WeekDayAdd' so now my durations are "skipping" over the weekends. But I can't seem to figure out how to get accurate dates for a department working 4 - 10s! Is there something I can add for this department to ignore Fridays as well like WeekDayAdd does for weekends?? All my calculations and formulas are accurate up to this point to convert a number of hours into 10 hour days, then displaying days on a Calendar, but because Fridays are being included, this department will show it's due earlier then it actually is (Based on how many Fridays the duration passes through)...
Thanks,
------------------------------
Alex Bennett
------------------------------
