#DateForumTypeThreadPost
725 Jun 2015 @ 01:56 PDTGeneralReplyGet the number of days in a monththanks Glass it worked perfectly ! Rgds Jx
624 Jun 2015 @ 06:14 PDTGeneralTopicGet the number of days in a monthHi Please assist I need to get the number of days in a month to do a calculation eg. 31, 28, 30 ect, in SQL i would do someting like this, but I'm stuck in Teradata. select DAY(DATEADD(mm, DA...
518 May 2015 @ 02:46 PDTGeneralReplyCalculate Running AvePerfect thanks Dieter, that is what I need.
417 May 2015 @ 11:05 PDTGeneralReplyCalculate Running AveThanks Dieter, but I need to only cal the average balance from where the account was active meaning the balance changed from 0 to whatever amount, if the account was active from 4th then the ave ca...
316 May 2015 @ 04:07 PDTGeneralTopicCalculate Running AveHi there, I'm trying to calculate the running ave, I have catered that it will start fresh evey month meaning day1-1, day1-2, day1-3, day1-4 ect, problem that I have is when an account is only ...
216 May 2015 @ 02:39 PDTGeneralReplyRetain amounts where NULL and divide by number of NULLSHi Dieter, this is great code, thanks a mill it really works good.
115 May 2015 @ 01:13 PDTGeneralTopicRetain amounts where NULL and divide by number of NULLSGood day, I'm trying to split the amounts evenly per day, some days are blank and therefore the prior amount should be used / 2 and first amount should be updates, when there are 2 blanks ...