Page 1 of 1

How to get the last day based on year and month

PostPosted: Mon Feb 12, 2018 10:31 pm
by viramu54
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

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

PostPosted: Tue Feb 13, 2018 5:17 am
by NicC
Wondering LASTDAYM would work

Why wonder? Why not try?