Hi everyone,
I am facing the following issue: I created a field using the formula monthend(invoice,1) to get the month end of an invoice for the next month.
I now want to compare the month end invoice date to a payment date. To do so I created the following expression:
If(payment < monthend, 'fine','issue')
This works for most cases but for some reason it gives back around 4 rows where the if statement is saying that its fine however in reality around 200 days would have passed so it should have been marked as an issue.
Anyone know what I might be doing incorrectly?
Thanks,
Isaac
