Defaulting Date to End of Month
I have a requirement where a user selects or enters the number of months the End Date should be extended by and the end date should default to the End of the Month. (30th or 31st of whichever month)
For Example :- My current start date is Jan 15 2020 and my current End Date is April 10 2020 ... so the current difference in months is three. The user is now presented a choice to extend the End Date by number of months (not a calendar field but an integer field).
If the user selects five (as the number of months), the End Date should fall on the LAST Day of the month i.e. June 30 2020 (and not June 10 2020 or June 15 2020).
If the user selects six (as the number months to extend the end data by), the End Date should fall on the LAST Day of the month i.e. July 31 2020 (and not July 10 2020 or July 15 2020).
If the user selects thirteen ( as the number of months), the End Date should fall on the LAST Day of the month i.e. February 28 2021 (and not February 10 2021 or February 15 2021).
How can I accomplish this and how can I account for leap years ?
Pegasystems Inc.
CA
You should be able to achieve this using Java. Check these out:
https://stackoverflow.com/questions/13624442/getting-last-day-of-the-month-in-a-given-string-date
Sky Solutions
US
Hello Chakri,
I have actually had to do this on my project, and came up with a solution. You can refer to this screen shot. The data transform will do the following. It will handle leap years as well.
- Take in a Parameter AddMonths (This will be the number of months you want to add)
- 1.1 Add +1 to the Param.AddMonths
- 1.2 Set TargetEndDate to CurrentEndDate + Param.AddMonths
- Note that we added 1 to the the AddMonths param so we force the date to be one month ahead.
- 1.3 Set TargetEndDate to the 1st of the month.
- 1.4 Subtract 1 day from the TargetEndDate. This will force the TargetEndDate to be the end of the month of the original target Added Months
