How to get the last day based on year and month
Posted: Mon Feb 12, 2018 10:31 pm
Hello,
I am trying to get the last day of the month based on the year and month value taking leap year into consideration .
Input : 201702
output should be : 2017-02-28
input : 201602
output should be : 2016-02-29
Any help would be appreciated as I am new to syncsort ... Wondering LASTDAYM would work ?
Thanks
I am trying to get the last day of the month based on the year and month value taking leap year into consideration .
Input : 201702
output should be : 2017-02-28
input : 201602
output should be : 2016-02-29
Any help would be appreciated as I am new to syncsort ... Wondering LASTDAYM would work ?
Thanks