add months

[raadwiptec]

is there a way to add months for MMM formats

for Ex: months like jan ,feb , mar.,

[Anonymous]

Yes,

Addmonths(Date(Date#(MonthField&-&YearField,'MMM-YYYY')),NumOfMonthsToAdd)

The number of months could be positive and negative.

Regards!

[agomes1971]

Hi,

Use AddMonths(startdate, n) where startdate is the date you wish to add to, n is the number of months (negative for prior months)

     AddMonths('2016/09/25', 3)  ->  2016/12/25

HTH

André Gomes

[saimahasan]

What output do you exactly need??

[miguelbraga]

Hey there,

Can you please calrify better your question. I can't seem to understand what your're trying to accomplish.

Regards,

MB