My whinge for the day.

[Ianpbaker]

In the app that I have been develpping for god knows how long, part of the requirement was to convert a rather complex excel spread sheet calculation into the new system. the calculation is to work an annuity amount for pensions. this obviously revolves round the DOB to make the calc. part of the old calc uses The DateFrac calculation which unfortunatley isn't in SQL. so I went off trauling the web to find out the formula for it. Nice and simple, it's the number of day's between two dates divided by the day basis. Good old Microsoft in their infinate wisdom don't take into account leap years in their version so although my calculation is correct, it is comming back slightly different from their existing system. Try explaining to the client that microsoft are wrong

[Gary.Lowe]

My answer to this is garbage data?

garbage in, garbage out.

And the retort to can you clean the data up is, Your garbage your problem

[Ianpbaker]

lol this just get's better and better, I now have the company split in half. the foward thinking Bosses are saying that they should use my version of the calc becuase it is more accurate and the other half saying that it should be exact with the old system. time for me to bugger outside for a *** and let them get on with the fisty cuffs

[donut]

Originally posted by Ianpbaker
time for me to bugger a *** outside

[gravyboy]

IanP said
Try explaining to the client that microsoft are wrong

Kind of similar to a problem I've got at the moment . . . . the client has a report which they give to a government authority (not uk). Previously they created this manually . . . now their software can do it.

However they are now claiming that the two don't match . . . . not bloody surprising since the data they are inputting to our software is absolute BULLSHIT. Try telling them that . . . . .

[chrisjk]

Everything here is so much more expensive than anywhere else
The cabinet is full of arseholes
It's cold, grey and ****
France is only 50 miles away

[chrismitchell]

Originally posted by chrisjk
Everything here is so much more expensive than anywhere else
The cabinet is full of arseholes
It's cold, grey and ****
France is only 50 miles away

And people wonder why i'm going away?



LOL

[Ianpbaker]

Originally posted by chrismitchell


And people wonder why i'm going away?



LOL

some one is getting quite anooying by rubing it in, in every single thread that he can

[chrismitchell]

Who me? Nothing wrong with it.. just do go flying off the handle at me