Confiforms: how to add a month to a date

[Patrick Liang]

I have a confiforms field with a date: 

[entry.date] that I can format it in a plainview as [entry.date.formatDate(MMM yyyy)]

I want to list the month year and the following 11 months and the year for example if the current record is Aug 2024, I'd like to list Aug 2024, Sep 2024..... Jul 2025.

How can I do so? Ideally something like this:

[entry.date.addMonth(1).formatDate(MMM yyyy)]

[entry.date.addMonth(2).formatDate(MMM yyyy)]

Thanks,

[Alex Medved _ConfiForms_ · Accepted solution]

May be something like this

[entry.date.formatDate(M).add(1).append( [entry.date.formatDate(yyyy)]).parseDate(M yyyy).formatDate(MMM yyyy)]

[Patrick Liang]

This works perfectly!!! Again nothing can stop Alex to provide a working solution. lol,

Much appreciated.

[Patrick Liang]

@Alex Medved _ConfiForms_  I have another field in the form called [entry.numberofmonths] that tells me how many months I'd like to display. Is it possible to do something like below to display all months? For example if the date is July 1, 2024, and the numberofmonths is 14, I'd like to display Jul 2024, ...... , Aug 2025. Thanks, again.

Plainview starts

---------------------------------------

#foreach ($i in [0..${numberofmonths}])

[entry.date.formatDate(M).add($i).append( [entry.date.formatDate(yyyy)]).parseDate(M yyyy).formatDate(MMM yyyy)]

#end

---------------------------------------

Plainview ends

[Alex Medved _ConfiForms_]

Generally I think it is all correct, what you are doing, but there must be some issue with a variable type

So, try doing this

#set($Integer = 0)


#foreach ($i in [0..$Integer.parseInt($numberofmonths)])
[entry.date.formatDate(M).add($i).append( [entry.date.formatDate(yyyy)]).parseDate(M yyyy).formatDate(MMM yyyy)] <br/>
#end

 To ensure the numberofmonths field is numeric for Velocity engine

[Jim Knepley - ReleaseTEAM]

[entry.date.add(ms)]

...uses milliseconds and a month is something like 2 * 10^9 ms milliseconds, so it might be awkward to use that, but I would start there.

[Patrick Liang]

Adding ms won't work because every month has different number of days. but thanks for your answer.