1 Reply Latest reply: Feb 17, 2010 3:49 PM by Neil Southern RSS

    Next Month

    Jean-Jacques Jesua

      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

       

       

       

        • Next Month

          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