NO OF WEEKS

vinod111 · Post by **vinod111** » Wed Oct 12, 2005 5:13 pm

When I tried to find out no of weeks with the formula that is Current Date - Hiredate /7 it gave me same no of days in each column.. How would I do this? It seems it is not recognizing different hiredates in each column.. Please let me know how would I find the no of weeks

kcbland · Post by **kcbland** » Wed Oct 12, 2005 6:40 pm

There are no datatypes in DS Server. You need to write a function to subtract dates. Better yet, have one that understands dates and time. Here's one I posted a long time ago:

viewtopic.php?t=85788

Create a function and paste this logic into it, it will do what you need most of the way. Have fun.

ray.wurlod · Post by **ray.wurlod** » Thu Oct 13, 2005 4:22 am

When you learned arithmetic at school, what did they teach you about precedence?

What's the difference between these two expressions?

CurrentDate - HireDate / 7

(CurrentDate - HireDate) / 7

The second of these will provide what you seek provided both dates are in DataStage internal format.

However, the result will be a decimal number - that is, it may include a fractional number of weeks. Adjust using the Int() function.

chulett · Post by **chulett** » Thu Oct 13, 2005 6:29 am

Not to derail this, but...

Ray, I could have sworn in the past you've said that DataStage was an odd duck in that it did not enforce any precedence when evaluating expressions? That it is, without parens, evaluated strictly from left to right. Am I mis-remembering?

kcbland · Post by **kcbland** » Thu Oct 13, 2005 7:10 am

That's correct, left to right when you don't have these ( guys ).

ray.wurlod · Post by **ray.wurlod** » Thu Oct 13, 2005 3:24 pm

chulett wrote:Not to derail this, but...

Ray, I could have sworn in the past you've said that DataStage was an odd duck in that it did not enforce any precedence when evaluating expressions? That it is, without parens, evaluated strictly from left to right. Am I mis-remembering?

I was talking about logic, not arithmetic. Arithmetic follows the rules. Logic (stuff with AND and OR) runs left to right unless parentheses occur.

chulett · Post by **chulett** » Thu Oct 13, 2005 3:30 pm

Ah. Thanks for the clarification... forgot the previous discussions were and/or related.