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
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