Next Month

[#1]

Hi,

I have a table with a field Monthname Jan09, Feb09, Mar09, ...

I'd like to calculate for each Monthname an expression depending of the next month. If I try Montname + 1 it doesnt work but if I try

Monthname +31 it works. Is there another way to use the next month

Thanks for any help

Jean-Jacques

[#2]

You should be able to use your date field with the monthstart function to get a specific date in that month.

From here you can then use the addmonths function for it to return next months data.

Hope this is of help,

Regards,

Neil