How to find if a date belongs to a complete month or not.
I have a field as Transaction_Date. Is there a means to find out if the max date belongs to current incomplete month or a complete month. I think it can be achieved using InmonthToDate function which returns true or false. But not sure how to use it.
=if(InMonthToDate(max(Link_Date)=-1),0,1)
By default the expression should return 1 since the current month is incomplete.
But if I select any date from the previous months it should be 0 since previous months would be complete.
