We had the exact same issue.
We fixed it by changing the logic to use ISO dates and a call to an RPG utility that adds/subtracts parts of dates.
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Howie, Bill
Sent: Monday, January 6, 2020 11:50 AM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: Julian date calculations across years
Hello all,
Is there a standard set of calcs out there to handle subtracting days from a Julian date where it goes across years? We have a report that blew up today because it tried to subtract 7 days from today's date and got a value of "2019999". I guess I thought Julian date calcs on the system knew how to handle that scenario. Thoughts?
Bill Howie | Senior ERP Programmer/Analyst Consultant The HC Companies | 2450 Edison Blvd, Suite 3, Twinsburg OH 44087
Direct: 330.487.3739 | Cell: 330.495.5627 | Toll Free: 800.225.7712
The HC Companies, Inc.<
http://www.hc-companies.com/> - North America's Leading Provider of Containers for Horticulture Dillen | ITML | ProCal | Kord | Amerikan | Planters' Pride From Grower to Gardener, Improving Our World [Related image]<
https://www.linkedin.com/company/the-hc-companies> [Related image] <
https://www.facebook.com/HCCompanies/>
Disclaimer
The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.
This email has been scanned for viruses and malware, and may have been automatically archived by Mimecast Ltd, an innovator in Software as a Service (SaaS) for business. Providing a safer and more useful place for your human generated data. Specializing in; Security, archiving and compliance. To find out more visit the Mimecast website.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
