Post

1 follower Follow
0
Avatar

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!!

Casey Bearsch

Please sign in to leave a comment.