Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
is there a way to add months for MMM formats
for Ex: months like jan ,feb , mar.,
Yes,
Addmonths(Date(Date#(MonthField&-&YearField,'MMM-YYYY')),NumOfMonthsToAdd)
The number of months could be positive and negative.
Regards!
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
What output do you exactly need??
Hey there,
Can you please calrify better your question. I can't seem to understand what your're trying to accomplish.
Regards,
MB