IBM Mainframe Forum

by **viramu54** » 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

by **NicC** » Tue Feb 13, 2018 5:17 am

Wondering LASTDAYM would work

Why wonder? Why not try?

IBM Mainframe Forum

How to get the last day based on year and month

How to get the last day based on year and month

Re: How to get the last day based on year and month