ContributionsMost RecentMost LikesSolutionsRe: How to add B. C. dates?Thank you for your response, Jeff. I am using this field for sorting out data chronologically. I've already created numeric fields, with dates before BC as a negative number. Actually, I am just putting in the year, as I don't need a precise date. But thanks for the suggestion anyway. ------------------------------ Aleksandra Rakita ------------------------------ How to add B. C. dates?Hello, Does anybody know how to add B. C. dates in the date field (for example 1/1/500 B.C.)? Is there any way to this using date field or should I create a formula instead? Thank you ------------------------------ Aleksandra Rakita ------------------------------ How to add B. C. years?Hello everyone, I have created a date field but I can't figure out how to add B.C. dates (for example 01.01.700 B.C.). Is there any way to do this? Thank you ------------------------------ Aleksandra Rakita ------------------------------ Re: How to write this formula in Quickbase?Thanks, Mark. That was easier than I thought. :) ------------------------------ Aleksandra R ------------------------------ How to write this formula in Quickbase?Hello, I hope someone with more experience can help me with this. I want to calculate a monthly payment for the loan using the following formula: A= P * (r+(1+r) n )/((1+r) n - 1) A= Monthly Payment, P= Loan Amount, r= Interest Rate, n= Payment Period. The part I am stuck with is (1+r) n Do you have any ideas about the best way to make this formula work? Thank you. ------------------------------ Aleksandra R. ------------------------------