Hi @eminogrande - you can use the DATEADD() function:

DATEADD(Date, 1, 'months')

More details here:

JB

Hi all,


I have the same question but, instead of wirting the duration (1 in exemple above) I want to refer to a previous column.


I tryed DATEADD({date},{field with duration},‘months’) but it doesn’t work (initial date is displayed)


The field with duration is a lookup from another table and is set as Number, integer format


Any idea?


Thanks for your help,


Laurent

A lookup field is actually an array. You can turn it into a string by adding quotation marks after it like this:

DATEADD({date},{field with duration}&"",'months')

Hi Scott,


It works fine.


I will check the meaning to understand and use it.


Many thanks,


Laurent