Thanks for showing your interest on my question! Appreciate it a lot.
Yes I did that, and I feel like that seems to be the problem.
Amazing that you’ve come up with a shorter formula! However,
when I tried it out, it still gives me the same error. I dissected your formula, and found out that (please expand each bullet):
Straight multiplication to a YEAR(Date) was ok. No error in the apps
But subtracting two value results of a multiplied YEAR() gives me the app error.
On the other hand, adding two value results of a multiplied YEAR() works, Why then does it not work in subtraction?
- (sorry I can’t show you the app view on the side as it contains sensitive info.)
When I try to input a text with a date format manually, the subtracting them works
But then again, when I try to convert my Dates to TEXT just to mimic the above formula, The app gets an error. Tho the expression says it's not erroneous. The App says error again.
And to add some context, I’m not sure if these are factors for the error?
DateofTransaction is an actual Column in my database, Date Column Type and not DateTime
- Auto Compute doesn’t have any formula, except for initial value - TODAY()
LastPrincipalChangeDate is a Virtual Column, Date Column Type and not DateTime (computed by getting the max Date of a specific table, but should be lower than DateofTransac)
- All else doesn’t have anything
This is the Info of the VC using the calculation
I’m just concerned the fact that, there’s nothing in the INFO > ERRORS to guide me on how I can troubleshoot this issue when I get that error in my app.
And that, the expression builder seems to tell me that, my expressions are not erroneous.
Maybe this is a bug?
Or it would really be helpful if anyone can give me an alternative formula to compute for months. I tried some month calculation formula in this forum, but were not working as I intended (e.g. some only limits it’s count to a year)