I am trying to get the most current 12 months of data based on a start date. so in this instance the start date is 3/1/2003. The most current 12 months would be from 3/1/2017 – 3/1/2018. The next record has a start date of 6/4/2006 … the most current full 12 months based on that date would 6/4/2016 -6/4/2017… does that help?
From: Db2Developer [mailto:bounce-Db2Developer@toadworld.com]
Sent: May 22, 2018 8:30
Subject: RE: [Toad for IBM DB2 - Discussion Forum] date question
RE: date question
Reply by Db2Developer
I am confused. Can you explain in greater detail? I dont understand how you are getting 3/1/2003 when you subtract 3/1/2017 and 3/1/2018. What is the formula you are using? Also are you using z/OS or LUW?
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from Toad for IBM DB2 Forum notifications altogether.
Toad for IBM DB2 - Discussion Forum
this post as spam/abuse.
Bay and Bay Transportation
This message is private and confidential. If you have received this message in error, please notify us and remove it from your system.