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
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,
Retrieving data ...