Re: Using SORT to generate sequential Dates

2022-07-06 Thread Billy Ashton
! Thank you and best regards, Billy Ashton -- Original Message -- From "Sri h Kolusu" To IBM-MAIN@listserv.ua.edu Date 6/30/2022 6:14:04 PM Subject Re: Using SORT to generate sequential Dates Billy, If I understand your requirement correctly, you need current month begin to end

Re: Using SORT to generate sequential Dates

2022-06-30 Thread Sri h Kolusu
>> I would also like for the date of Easter, day of the week Christmas falls >> on, the moon phase, and the Chinese zodiac year to be appended. Steve, Your wish is granted for Easter day  https://www.mvsforums.com/helpboards/viewtopic.php?p=63383#63383 Thanks, Kolusu DFSORT Development IBM

Re: Using SORT to generate sequential Dates

2022-06-30 Thread David Spiegel
--Original Message- From: IBM Mainframe Discussion List On Behalf Of Paul Gilmartin Sent: Thursday, June 30, 2022 3:29 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Using SORT to generate sequential Dates On Thu, 30 Jun 2022 22:22:08 +, Sri h Kolusu wrote: I tried this in Rexx

Re: Using SORT to generate sequential Dates

2022-06-30 Thread Steve Smith
wrote: > -Original Message- > From: IBM Mainframe Discussion List On Behalf > Of > Paul Gilmartin > Sent: Thursday, June 30, 2022 3:29 PM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: Using SORT to generate sequential Dates > > On Thu, 30 Jun 2022 22:22:08 +, Sri

Re: Using SORT to generate sequential Dates

2022-06-30 Thread Andrew Rowley
On 1/07/2022 8:13 am, Paul Gilmartin wrote: I tried this in Rexx. I found it astonishingly hard to get "the end of the current month". Would DFSORT do betteer? I tried it in Java: import java.time.LocalDate; import java.time.format.DateTimeFormatter; public class DateList {     public

Re: Using SORT to generate sequential Dates

2022-06-30 Thread Retired Mainframer
-Original Message- From: IBM Mainframe Discussion List On Behalf Of Paul Gilmartin Sent: Thursday, June 30, 2022 3:29 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Using SORT to generate sequential Dates On Thu, 30 Jun 2022 22:22:08 +, Sri h Kolusu wrote: >>>I tried thi

Re: Using SORT to generate sequential Dates

2022-06-30 Thread Sri h Kolusu
>> So it accounts for thee switch from Julian to Gregorian in Catholic >> countries in 1582 and in Protestant countries in 1752? Not really. For older years. it just follows the general rules of Leap year and it is not specific to any country. Thanks, Kolusu

Re: Using SORT to generate sequential Dates

2022-06-30 Thread Charles Mills
If your data goes back that far. Charles -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Paul Gilmartin Sent: Thursday, June 30, 2022 3:29 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Using SORT to generate sequential Dates On Thu

Re: Using SORT to generate sequential Dates

2022-06-30 Thread Paul Gilmartin
On Thu, 30 Jun 2022 22:22:08 +, Sri h Kolusu wrote: >>>I tried this in Rexx. I found it astonishingly hard to get "the end of the >>>current month". > >DFSORT has plethora of date related functions that can get the last day of >month, Quarter and year quite easily in either Gregorian

Re: Using SORT to generate sequential Dates

2022-06-30 Thread Paul Gilmartin
On Thu, 30 Jun 2022 17:29:31 -0400, Billy Ashton wrote: >... >Having more dates than this is fine, and is no problem to go back even >another month and ahead even another month. > So would current date - 61 days through current date + 30 days be acceptable in all cases? -- gil

Re: Using SORT to generate sequential Dates

2022-06-30 Thread Sri h Kolusu
>>I tried this in Rexx. I found it astonishingly hard to get "the end of the >>current month". DFSORT has plethora of date related functions that can get the last day of month, Quarter and year quite easily in either Gregorian format or Julian format. //STEP0100 EXEC PGM=SORT //SYSOUT DD

Re: Using SORT to generate sequential Dates

2022-06-30 Thread Sri h Kolusu
n Behalf Of Billy Ashton Sent: Thursday, June 30, 2022 2:30 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: [EXTERNAL] Re: Using SORT to generate sequential Dates Kolusu, the key data is that I have the previous month start and end date (for today, it would be May 1 and 31), with some range of dates before that

Re: Using SORT to generate sequential Dates

2022-06-30 Thread Paul Gilmartin
On Thu, 30 Jun 2022 20:23:16 +, Billy Ashton wrote: >... >I would like to use SORT to generate a file ... > >I need this for about 3 months worth of dates. The dates should start >either on the 15th of the month, 2 months ago, or 45 days ago (whichever >is easier) and go up through the

Re: Using SORT to generate sequential Dates

2022-06-30 Thread Billy Ashton
Kolusu, the key data is that I have the previous month start and end date (for today, it would be May 1 and 31), with some range of dates before that. I also need at least the end of the current month (June 30, today). For running it tomorrow, I need at least June 1 - 30 (with some dates in

Re: Using SORT to generate sequential Dates

2022-06-30 Thread Sri h Kolusu
>> I need this for about 3 months worth of dates. . The dates should start >> either on the 15th of the month, 2 months ago, or 45 days ago (whichever is >> easier) Billy, It is easy to generate the dates in the required format, however a few clarifications needed. • Can the dates

Using SORT to generate sequential Dates

2022-06-30 Thread Billy Ashton
Hello all! I have a new SORT challenge... I have looked up and found out how to use SORT to get the current date and output it, but I need to go further, and could not find this. I would like to use SORT to generate a file like this that I am using for testing some SQL logic I am working