![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Wed, 14 Sep 2011 @ 09:07:01 GMT
Subj: | | Mdiff on Date field |
|
From: | | Anomy Anom |
<-- Anonymously Posted: Wednesday, September 14, 2011 04:43 -->
HI All,
I am trying to use mdiff on date field. It is working however when the month/year changes, the mdiff values are wrongly interpreted. I guess
this is due to the fact that TD stores date as integerdate. Can someone help me on to get the correct difference b/w two consecutive rows
irrespective of month/year?
ID date Mdiff Ideal value should be
1 28-Jan null null
1 31-Jan 3 3
1 1-Feb 71 1
| |