Remove Every Other Friday

Z

zero635

Well, I am working with Crystal Reports. I know that it can b
programmed using Basic Syntax. I cannot find the answer I am lookin
for and was hoping some here could help.

I need to take evey other friday out of the my equation.

I have queues and when an item is moved to a different queue it is tim
stamped with a start date. I am then taking the start date an
subtracting Saturdays and Sundays. Now I am faced with trying to tak
out my off fridays with fall every other friday.

Is there a way to give a known friday off and then count the friday
off and subtract them from the given start date?

i.e Start Date = (07/25/06) - (07-28-06) - (08-11-06)
**
The formula I have in the currently is as follows and it takes out th
saturdays and sundays

DateDiff("d",{ITEM_QUEUE.START_DATE},(CurrentDate))-
DateDiff("ww",{ITEM_QUEUE.START_DATE}, (CurrentDate)
crSaturday)-
DateDiff("ww",{ITEM_QUEUE.START_DATE}, (CurrentDate), crSunday)

If anyone can put me on track to figuring this out much would b
appreciated.:eek
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top