gabehcoud said:

---

cast(floor(day(T.eff_date - E.eff_date) / 30) *1.0 as DECIMAL (10,2))

gdammit.

will follow rules when i get off my work computer

---

Quote:

---

CAST(FLOOR(DATEDIFF(T.eff_date, E.eff_date) / 30.0) AS DECIMAL(10, 2))

---

Lake08 said:

---

gabehcoud said:

---

I tried it with/without a hundred different ways. Decided I was being stupid wasting time and just did it as a variable field in the BI tool. Pisses me off when I can't do something with sql that I can do with a simple excel formula.

---

Are u speaking English???

---

gabehcoud said:

---

CAST(FLOOR(DATE_DIFF('day',E.eff_date, T.eff_date) / 30.0) AS DECIMAL(10, 2))

nope, still returns an integer

---

Quote:

---

There are two potential reasons why this expression might not be returning a decimal even though you're casting it to
DECIMAL(10,2)
:
[ol]

Integer Division: The part floor(day(T.eff_date - E.eff_date) / 30) performs integer division. This means it will discard any remainder after the division and only return the whole number quotient. Even if the result of day(T.eff_date - E.eff_date)
is a decimal (due to difference in days being a fraction), dividing by 30 might result in an integer.

Unnecessary Casting: Multiplying the result by 1.0 before casting might be redundant. Casting to DECIMAL itself should be enough to convert the result to a decimal data type.

[/ol]

---

Quote:

---

CAST(FLOOR((day(T.eff_date - E.eff_date) / 30.0) * 1.0) AS DECIMAL(10,2))
-- OR
CAST(FLOOR(decimal_division(day(T.eff_date - E.eff_date), 30)) AS DECIMAL(10,2))

---

Philo B 93 said:

---

Actually, I'd like to jump in and take that one, Jimmy, If you don't mind. Recent research has shown that empirical evidence for globalization of corporate innovation is very limited and as a corollary the market for technologies is shrinking. As a world leader, it's important for America to provide systematic research grants for our scientists. I believe strongly there will always be a need for us to have a well-articulated innovation policy with emphasis on human resource development. Thank you.

---