Date Calculation.

karry450 · Post by **karry450** » Fri Jun 27, 2008 7:07 am

Hi friends,

I have a column in target as AGE which should be as (a.date minus b.date) minus weekends(saturday and sunday)

can anyone help me how to apply/Implement this in my server jobs.

Thanks

ArndW · Post by **ArndW** » Fri Jun 27, 2008 7:17 am

Not quite sure what the rule is, what is the formula and answer for this age:

Date1 27/06/2008
Date2 01/06/2008

kcbland · Post by **kcbland** » Fri Jun 27, 2008 8:30 am

Use a TIME dimension and count the number of business days between two rows. Summing a "business day indicator" is a handy trick.

chulett · Post by **chulett** » Fri Jun 27, 2008 8:40 am

Ah... now I know Ken is back.

kcbland · Post by **kcbland** » Fri Jun 27, 2008 8:51 am

Yeah, well, working 90 hour weeks for the last two months means exhaustion. This is my last week straddling two customer projects 1300 miles apart. Starting next week I'm hoping to have my usual presence again.

ray.wurlod · Post by **ray.wurlod** » Fri Jun 27, 2008 4:03 pm

Using your time dimension/calendar table also means that you can take into account holidays should you need to.