JesseEdsell-Vet
8 months agoQrew Member
Loan database - Interest period
Hi all I am creating an interest calculator report for our finance folks. I have a duration field to count the number of days between key dates for interest calculations but am running into 2 challe...
- 8 months ago
If you have a field called [# of days]
which is a formula numeric field type, you can use
ToDays([End Date] - [Start Date])
Yes, probably grid edit is the best idea. The alternative would be to export the data to excel, including the key field, which is probably the record ID field, somehow fill in the dates in excel and then import that one field and the record ID back into your database.