Add one month to date, but keep exact same day or last day of the month if higher
Hello.
I have the following requirement: for a given DateTime, I need to get the same date + one month. However, if the day is, for example, the 31st, and the following month has only 30 days or less, I need it be the last day of the following month.
I could have use a function to add days and add 30 days to the current date, or use an existing function to add one month, but I'm affraid the date could shift on the next month (like changing from 26 to 25 of the month).
In practice, these are some example of results I'd like to have:
26/06->26/07->26/08...
01/06->01/07->01/08...
31/05->30/06->31/07...
30/06->30/07->30/08...
Is there an ootb existing function for this? Or do I need to use java code or activity for this?
Thanks in advance.
Accepted Solution
Iriz Consulting
FR
I ended up developping my own java function.
It uses only the Calendar library and a String parameter, "theDate". So I guess it could help people having the same requirement.
Calendar cal = Calendar.getInstance();
DateTimeUtils dtu = ThreadContainer.get().getDateTimeUtils();
//get info of date in parameter
cal.setTime(dtu.parseDateTimeString(theDate));
int year = cal.get(Calendar.YEAR);
int month = cal.get(Calendar.MONTH);
int day = cal.get(Calendar.DAY_OF_MONTH);
//get number of max days of next month
Calendar NewCal = Calendar.getInstance();
NewCal.set(year, month, 1);
NewCal.add(Calendar.MONTH, 1);
int nextMax=NewCal.getActualMaximum(Calendar.DAY_OF_MONTH);
if(nextMax>=day) //if max day of next month is lower than current day, just add one month
{
cal.set(year,month,1);
cal.add(Calendar.MONTH, 1);
cal.set(Calendar.DAY_OF_MONTH, day);
} else { //if not: go to next month, set day to maximum number of day
cal.set(year,month,1);
cal.add(Calendar.MONTH, 1);
cal.set(Calendar.DAY_OF_MONTH, nextMax);
}
return dtu.formatDateTimeStamp(cal.getTime());
Pegasystems Inc.
IN
There is no OOTB function for this exact requirement. You need to write your own logic for this.
Let us know if you need any information :)
Accepted Solution
Iriz Consulting
FR
I ended up developping my own java function.
It uses only the Calendar library and a String parameter, "theDate". So I guess it could help people having the same requirement.
Calendar cal = Calendar.getInstance();
DateTimeUtils dtu = ThreadContainer.get().getDateTimeUtils();
//get info of date in parameter
cal.setTime(dtu.parseDateTimeString(theDate));
int year = cal.get(Calendar.YEAR);
int month = cal.get(Calendar.MONTH);
int day = cal.get(Calendar.DAY_OF_MONTH);
//get number of max days of next month
Calendar NewCal = Calendar.getInstance();
NewCal.set(year, month, 1);
NewCal.add(Calendar.MONTH, 1);
int nextMax=NewCal.getActualMaximum(Calendar.DAY_OF_MONTH);
if(nextMax>=day) //if max day of next month is lower than current day, just add one month
{
cal.set(year,month,1);
cal.add(Calendar.MONTH, 1);
cal.set(Calendar.DAY_OF_MONTH, day);
} else { //if not: go to next month, set day to maximum number of day
cal.set(year,month,1);
cal.add(Calendar.MONTH, 1);
cal.set(Calendar.DAY_OF_MONTH, nextMax);
}
return dtu.formatDateTimeStamp(cal.getTime());