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.
