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
Date Calculation.
Moderators: chulett, rschirm, roy
Use a TIME dimension and count the number of business days between two rows. Summing a "business day indicator" is a handy trick.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
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.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: