<div dir="ltr"><div dir="ltr"><div class="gmail_default" style="font-family:"comic sans ms",sans-serif;font-size:large;color:rgb(0,0,153)">Hi Helen</div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif;font-size:large;color:rgb(0,0,153)"><br></div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif;font-size:large;color:rgb(0,0,153)">pdl setup ?</div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif;font-size:large;color:rgb(0,0,153)"><br></div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif;font-size:large;color:rgb(0,0,153)">if default century specified ?</div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif;font-size:large;color:rgb(0,0,153)"><br></div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif;font-size:large;color:rgb(0,0,153)">qshow</div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif;font-size:large;color:rgb(0,0,153)"><br></div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif;font-size:large;color:rgb(0,0,153)">show all</div><div class="gmail_default" style="font-family:"comic sans ms",sans-serif;font-size:large;color:rgb(0,0,153)"><br></div><div class="gmail_default"><div class="gmail_default"><font color="#000099" size="4" face="monospace, monospace"> Created: On 2019/02/26 By PDL 8.43.G</font></div><div class="gmail_default"><font color="#000099" size="4" face="monospace, monospace"><br></font></div><div class="gmail_default"><font color="#000099" size="4" face="monospace, monospace"> -- Date Options --</font></div><div class="gmail_default"><font color="#000099" size="4" face="monospace, monospace"> Century Included?: Yes Default Century: 20</font></div><div class="gmail_default"><font color="#000099" size="4" face="monospace, monospace"> Date Picture: YYYY/MM/DD Input Century: not specified</font></div><div class="gmail_default"><font color="#000099" size="4" face="monospace, monospace"> Nullseparator: not specified Allow Century: not specified</font></div><div class="gmail_default"><font color="#000099" size="4" face="monospace, monospace"> Force Century: not specified Date Parm Inherit: No</font></div></div></div></div><div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br>
<table style="border-top:1px solid #d3d4de">
<tr>
<td style="width:55px;padding-top:13px"><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif" alt="" width="46" height="29" style="width: 46px; height: 29px;"></a></td>
<td style="width:470px;padding-top:12px;color:#41424e;font-size:13px;font-family:Arial,Helvetica,sans-serif;line-height:18px">Virus-free. <a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank" style="color:#4453ea">www.avast.com</a>
</td>
</tr>
</table><a href="#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"></a></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Feb 28, 2019 at 9:11 AM Helen Wellcome <<a href="mailto:HWellcom@wsboces.org">HWellcom@wsboces.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div lang="EN-US">
<div class="gmail-m_-1601240359270420069WordSection1">
<p class="MsoNormal"><span style="color:rgb(31,73,125)">I have since found out its not the days function as I had originally thought when the problem occurred.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">While debugging , I found that it was the entered date.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">Its when entering a date on a screen that has a year greater than 2019 that the century is becoming 1900 instead of 2000.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">helen<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)"><u></u> <u></u></span></p>
<div>
<div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid rgb(181,196,223);padding:3pt 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10pt;font-family:Tahoma,sans-serif">From:</span></b><span style="font-size:10pt;font-family:Tahoma,sans-serif"> Herald Kaffka [mailto:<a href="mailto:Herald.Kaffka@westfraser.com" target="_blank">Herald.Kaffka@westfraser.com</a>]
<br>
<b>Sent:</b> Thursday, February 28, 2019 8:22 AM<br>
<b>To:</b> Robert Deskin; Helen Wellcome<br>
<b>Cc:</b> power-l List<br>
<b>Subject:</b> RE: [External] Re: having issues with DAYS function in Qdesign<u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">You guys scared me, I need to get about 2 more years out of “old faithful” before she gets put out to pasture… (I don’t need any date problems with next year…).<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">On Itanium/VMS at least, dates in 2020 appear to be working as expected…<u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:r_ansi"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:r_ansi">$ quiz<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:r_ansi">IBM(R) Cognos(R) PowerHouse(R) 4GL 8.40G - QUIZ<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:r_ansi">(C) Copyright IBM Corp. 1982, 2010<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:r_ansi"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:r_ansi">> use date<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:r_ansi">> define d-days num*8 = days(20200620)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:r_ansi">> define d-date date = date(days(20200620))<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:r_ansi">> report d-days d-date<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:r_ansi">> go<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:r_ansi">02/28/19 WEST FRASER: M D S - R8.40gP PAGE 1<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:r_ansi"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:r_ansi"> D-DAYS D-DATE<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:r_ansi"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:r_ansi"> 44001 06/20/20<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:r_ansi"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:r_ansi">?<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:r_ansi">Records selected: 0<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:r_ansi">Lines printed: 3<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:r_ansi">Pages printed: 1<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10pt;font-family:r_ansi"><u></u> <u></u></span></p>
<p class="MsoNormal">Don’t know if it helps with the immediate problem, but it does imply that the core system engine is probably OK…<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid rgb(225,225,225);padding:3pt 0in 0in">
<p class="MsoNormal"><b>From:</b> powerh-l <<a href="mailto:powerh-l-bounces@lists.sowder.com" target="_blank">powerh-l-bounces@lists.sowder.com</a>> <b>
On Behalf Of </b>Robert Deskin<br>
<b>Sent:</b> Wednesday, February 27, 2019 4:04 PM<br>
<b>To:</b> Helen Wellcome <<a href="mailto:HWellcom@wsboces.org" target="_blank">HWellcom@wsboces.org</a>><br>
<b>Cc:</b> power-l List <<a href="mailto:powerh-l@lists.sowder.com" target="_blank">powerh-l@lists.sowder.com</a>><br>
<b>Subject:</b> [External] Re: having issues with DAYS function in Qdesign<br>
<b>Importance:</b> High<u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">I honestly can’t remember if there’s a size limit, but even the days in the early 2000s were over 32,768.<u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Have you tried a simple QUIZ report displaying the value of DAYS(20200630)? Are you using 8-digit dates?<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">If DAYS is not working, you might try using DECIMALTIME without using any time portion, and set the base date to 20000101. That gives you days since January 1, 2000.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">I’m only going by what the manuals say because I no longer have a working version of PowerHouse available to me.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Bob<u></u><u></u></p>
<div>
<p class="MsoNormal" style="margin-bottom:12pt"><u></u> <u></u></p>
<blockquote style="margin-top:5pt;margin-bottom:5pt">
<div>
<p class="MsoNormal">On Feb 27, 2019, at 1:42 PM, Helen Wellcome <<a href="mailto:HWellcom@wsboces.org" target="_blank">HWellcom@wsboces.org</a>> wrote:<u></u><u></u></p>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal"><span style="color:rgb(31,73,125)"> </span><span style="font-size:12pt;font-family:"Times New Roman",serif"><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">Important . </span><span style="font-size:12pt;font-family:"Times New Roman",serif"><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">We were trying to create a school calendar for the school year 201920 . our program says that the days were created (between 090419 – 063020) but nothing gets outputted . the logic is falling thru our
loops.</span><span style="font-size:12pt;font-family:"Times New Roman",serif"><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">We have no problem creating a new 201819 calendar group</span><span style="font-size:12pt;font-family:"Times New Roman",serif"><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:rgb(31,73,125)"> </span><span style="font-size:12pt;font-family:"Times New Roman",serif"><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:rgb(31,73,125)"> </span><span style="font-size:12pt;font-family:"Times New Roman",serif"><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">06/30/2020 is not converting right for DAYS function.</span><span style="font-size:12pt;font-family:"Times New Roman",serif"><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:rgb(31,73,125)"> </span><span style="font-size:12pt;font-family:"Times New Roman",serif"><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">Please help as this covers MANY areas of our BILLING also.</span><span style="font-size:12pt;font-family:"Times New Roman",serif"><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:rgb(31,73,125)"> </span><span style="font-size:12pt;font-family:"Times New Roman",serif"><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">Helen Wellcome</span><span style="font-size:12pt;font-family:"Times New Roman",serif"><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">Western Suffolk BOCES</span><span style="font-size:12pt;font-family:"Times New Roman",serif"><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:rgb(31,73,125)">(631) 595-6887</span><span style="font-size:12pt;font-family:"Times New Roman",serif"><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:rgb(31,73,125)"><a href="mailto:hwellcom@wsboces.org" target="_blank"><span style="color:purple">hwellcom@wsboces.org</span></a></span><span style="font-size:12pt;font-family:"Times New Roman",serif"><u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:rgb(31,73,125)"> </span><span style="font-size:12pt;font-family:"Times New Roman",serif"><u></u><u></u></span></p>
</div>
<p class="MsoNormal"><span style="font-size:12pt;font-family:LucidaGrande,serif">CONFIDENTIALITY NOTICE: The information contained in this message is confidential, and is intended only for the addressee. If the reader of this message is not the intended
recipient, or employee or agent responsible for delivering it to the intended recipient, you are hereby notified that dissemination, distribution, or copying of this communication or any of its content is strictly prohibited and may be unlawful. If you have
received this communication in error, please notify us promptly at (631) 549-4900 and destroy the email and any copies. --<span class="gmail-m_-1601240359270420069apple-converted-space"> </span><br>
= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>
Mailing list:<span class="gmail-m_-1601240359270420069apple-converted-space"> </span></span><a href="mailto:powerh-l@lists.sowder.com" target="_blank"><span style="font-size:12pt;font-family:LucidaGrande,serif;color:purple">powerh-l@lists.sowder.com</span></a><span style="font-size:12pt;font-family:LucidaGrande,serif"><br>
Subscribe: 'subscribe' in message body to<span class="gmail-m_-1601240359270420069apple-converted-space"> </span></span><a href="mailto:powerh-l-request@lists.sowder.com" target="_blank"><span style="font-size:12pt;font-family:LucidaGrande,serif;color:purple">powerh-l-request@lists.sowder.com</span></a><span style="font-size:12pt;font-family:LucidaGrande,serif"><br>
Unsubscribe: 'unsubscribe <password>' in message body to<span class="gmail-m_-1601240359270420069apple-converted-space"> </span></span><a href="mailto:powerh-l-request@lists.sowder.com" target="_blank"><span style="font-size:12pt;font-family:LucidaGrande,serif;color:purple">powerh-l-request@lists.sowder.com</span></a><span style="font-size:12pt;font-family:LucidaGrande,serif"><br>
</span><a href="https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.sowder.com%2Fmailman%2Flistinfo%2Fpowerh-l&data=01%7C01%7Cherald.kaffka%40westfraser.com%7C7069619e48f944a950af08d69d0124c5%7C34ad3be0bbba4db0a8e8933abd884c7d%7C1&sdata=brX5ujmvTdBnpa8HssJypE22sy4HI1yaiVHfFEF4XjM%3D&reserved=0" target="_blank"><span style="font-size:12pt;font-family:LucidaGrande,serif;color:purple">https://lists.sowder.com/mailman/listinfo/powerh-l</span></a><span style="font-size:12pt;font-family:LucidaGrande,serif"><br>
This list is closed, thus to post to the list you must be a subscriber.<br>
Add 'site:</span><a href="https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Flists.sowder.com%2F&data=01%7C01%7Cherald.kaffka%40westfraser.com%7C7069619e48f944a950af08d69d0124c5%7C34ad3be0bbba4db0a8e8933abd884c7d%7C1&sdata=mJcecMBzy%2BCawPNqS9A3xBoAckvwGe%2F3Ju9c9JK9eUg%3D&reserved=0" target="_blank"><span style="font-size:12pt;font-family:LucidaGrande,serif;color:purple">lists.sowder.com</span></a><span class="gmail-m_-1601240359270420069apple-converted-space"><span style="font-size:12pt;font-family:LucidaGrande,serif"> </span></span><span style="font-size:12pt;font-family:LucidaGrande,serif">powerh-l'
to your search terms to search the list archive at Google.</span><u></u><u></u></p>
</div>
</blockquote>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<p><br>
<br>
-------------EOP--------------- <br>
<br>
This e-mail message and any attachments are confidential. Any dissemination or use of this information by a person other than the intended recipient is unauthorized. If you are not the intended recipient, please notify me by return e-mail, do not open any attachment
and delete this communication and any copy. <br>
<br>
Thank you <u></u><u></u></p>
</div>
</div>
-- <br>
= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>
Mailing list: <a href="mailto:powerh-l@lists.sowder.com" target="_blank">powerh-l@lists.sowder.com</a><br>
Subscribe: 'subscribe' in message body to <a href="mailto:powerh-l-request@lists.sowder.com" target="_blank">powerh-l-request@lists.sowder.com</a><br>
Unsubscribe: 'unsubscribe <password>' in message body to <a href="mailto:powerh-l-request@lists.sowder.com" target="_blank">powerh-l-request@lists.sowder.com</a><br>
<a href="https://lists.sowder.com/mailman/listinfo/powerh-l" rel="noreferrer" target="_blank">https://lists.sowder.com/mailman/listinfo/powerh-l</a><br>
This list is closed, thus to post to the list you must be a subscriber.<br>
Add 'site:<a href="http://lists.sowder.com" rel="noreferrer" target="_blank">lists.sowder.com</a> powerh-l' to your search terms to search the list archive at Google.</blockquote></div><div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br>
<table style="border-top:1px solid #d3d4de">
<tr>
<td style="width:55px;padding-top:13px"><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif" alt="" width="46" height="29" style="width: 46px; height: 29px;"></a></td>
<td style="width:470px;padding-top:12px;color:#41424e;font-size:13px;font-family:Arial,Helvetica,sans-serif;line-height:18px">Virus-free. <a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank" style="color:#4453ea">www.avast.com</a>
</td>
</tr>
</table><a href="#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"></a></div>