Forum Discussion

SergioSergio's avatar
SergioSergio
Qrew Cadet
8 years ago

pull information from a field in another table from the respective field based on the month of the year

I have two tables. "Processing" and "Monthly Interest Rate". I have a field in the processing table that is called [interest rate] I have fields in the "interest rate table" called [JAN 2018], [FE...
Ask about Quickbase functionality
SergioSergio's avatar
SergioSergio
Qrew Cadet
8 years ago
Hi Mark,

Yes i did. 
I does work for records that have the data of transaction on the first day of the month, but its does not work for the other days.
Dont I need to add something to the formula to pick up the other days?
FirstDayOfMonth([DATE OF TRANSACTION])
It only works for transactions done on the first day, the other days it doesnt work,