The trick is to match your business rules. INTNX allows you variations to get end of month value, using an interval of 0, with end or beginning option for example. You haven't specified the rules so we can't help beyond this, but hopefully it gets you started.
... View more