Calculation of time from a date field
When we look at our account base we use a date field of last invoice to determine if an account is active or in active, this time frame is 18 months.
I have added a calculation field to calculate the time past from today's date from a date field in the app; and it displays properly
moment(@Last Invoice Date).fromNow()
My aim is to add a If statement to and test the output to see IF that output is greater than 18 months then print "Inactive" Else ""Active"
I have tried a few syntax variations and I am reviving a error I am sure it is something simple that I am overlooking.
Thank you in advance!!
Please sign in to leave a comment.