To end of next month

[mdr]

Hello,

I would like to create a filter on my .imr with a formula that gives me data until the end of next month. eg.

today = 10th nov 2004. - data returned until = 31st dec 2004

today = 10th dec 2004 - data returned until = 31 jan 2005.

i have all the dates in a "sales date" column, but want to filter for reasons of clarity.

Any help appreciated.

 

[DoubleD]

Last-Of-Month(Add-Months([Sales Date],1))

I am what I am based on the decisions I have made.

DoubleD

 

[mdr]

Thank you very much.