Money or float

Post Reply New Topic

Just a quiz thread,

I have a table with a "from date", a "to date", and a total interest amount. I need to work out, on a simple interest basis, the proportion of interest applicable to a subset of days within this range. Basically I'm using datediff to get the number of days between the two, then calculating the number of days from my own starting date to the to date and dividing this by the total to get the fraction to multiply by the interest applied, or Interest = P * R * T. Once customer cashes out I need to store the interest earned and keep track of all interest paid out.....

So whilst on business layer I'll only show the total paid to customer up to ,2 digit precision

What data type would I store this as?