topic Re: add months in QlikView

add months

raadwiptec — Wed, 25 Nov 2020 16:16:04 GMT

is there a way to add months for MMM formats

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

Anonymous — Mon, 05 Sep 2016 10:02:29 GMT

Yes,

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

The number of months could be positive and negative.

Regards!

agomes1971 — Mon, 05 Sep 2016 10:42:10 GMT

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 — Mon, 05 Sep 2016 13:09:43 GMT

What output do you exactly need??

miguelbraga — Mon, 05 Sep 2016 13:31:18 GMT

Hey there,

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

Regards,