Question
Capgemini
IN
Last activity: 4 May 2022 0:01 EDT
How to get the Last day of any month?
From a service I am getting date like this yyyyMM for example 199804. We need to append Last day of the month with this date.
Any idea how to do that?
I didn't found any inbuilt function for the same?
I am looking for any inbuilt function for that as I dont want to add conditionally date in a DT or activity.
***Edited by Moderator Marije to add Capability tags***
Accepted Solution
Updated: 4 May 2022 0:01 EDT
Capgemini
IN
I found the solution like this --
@addTodate(@addToDate(("date string"+"01"),0,1,0),-1,0,0)
How it is working:
Here "date string" is in format yyyyDD for example 199804
1. First append "01" to make it 19980401
2. Inner function to add one month to make it 19980501
3. Outer function to minus 1 day to make it 19980430
Updated: 29 Apr 2022 1:38 EDT
Eclatprime Digital Private Limited
IN
I don't think there is any OOTB Function to achieve that. You need to write your own function for this.
There are plenty of options available to write that java code.
Accepted Solution
Updated: 4 May 2022 0:01 EDT
Capgemini
IN
I found the solution like this --
@addTodate(@addToDate(("date string"+"01"),0,1,0),-1,0,0)
How it is working:
Here "date string" is in format yyyyDD for example 199804
1. First append "01" to make it 19980401
2. Inner function to add one month to make it 19980501
3. Outer function to minus 1 day to make it 19980430