How to get the last day based on year and month



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

How to get the last day based on year and month

Postby 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
viramu54
 
Posts: 1
Joined: Mon Feb 12, 2018 10:25 pm
Has thanked: 0 time
Been thanked: 0 time

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

 

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

Postby NicC » Tue Feb 13, 2018 5:17 am

Wondering LASTDAYM would work

Why wonder? Why not try?
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2715
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 107 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post