[External] Re: having issues with DAYS function in Qdesign

Thu Feb 28 21:52:47 CST 2019

So, from the documentation:

INPUT CENTURY century FROM [YEAR] year

Establishes an input century window. The window is used to determine which century value will

be added to a century-included date when only a two-digit year is input.

This option applies to century-included dates input in QUICK, QUIZ, and QTP.

The INPUT CENTURY values are not compiled into PowerHouse applications. To change the

INPUT CENTURY values, you change the PDL option and recompile the dictionary. It is not

necessary to recompile your application to change the INPUT CENTURY window.

If the INPUT CENTURY is not specified, the DEFAULT CENTURY is used as the default input

century.

From: powerh-l <powerh-l-bounces at lists.sowder.com> On Behalf Of Steve Miller
Sent: February 28, 2019 3:46 PM
To: Helen Wellcome <HWellcom at wsboces.org>; power-l List <powerh-l at lists.sowder.com>
Subject: RE: [External] Re: having issues with DAYS function in Qdesign

Check your dictionary for an “INPUT CENTURY 19 FROM YEAR 20” line.  This creates a window where years xx20-xx99 are century 19 and xx00 to xx19 are century 20.  This sounds exactly like the behavior you are seeing.

Steve Miller

 <https://www.freschesolutions.com/> 

Steve Miller
Manager, Expertise Resourcing

Fresche Solutions
 <https://www.freschesolutions.com/> https://www.freschesolutions.com

From: powerh-l <powerh-l-bounces at lists.sowder.com <mailto:powerh-l-bounces at lists.sowder.com> > On Behalf Of Helen Wellcome
Sent: Thursday, February 28, 2019 8:07 AM
To: Herald Kaffka <Herald.Kaffka at westfraser.com <mailto:Herald.Kaffka at westfraser.com> >; Robert Deskin <bob.deskin at me.com <mailto:bob.deskin at me.com> >
Cc: power-l List <powerh-l at lists.sowder.com <mailto:powerh-l at lists.sowder.com> >
Subject: RE: [External] Re: having issues with DAYS function in Qdesign

I have since found out its not the days function as I had originally thought when the problem occurred.

While debugging , I found that it was the entered date.

Its when entering a date on a screen that has a year greater than 2019      that the century is becoming 1900 instead of 2000.

helen

From: Herald Kaffka [mailto:Herald.Kaffka at westfraser.com] 
Sent: Thursday, February 28, 2019 8:22 AM
To: Robert Deskin; Helen Wellcome
Cc: power-l List
Subject: RE: [External] Re: having issues with DAYS function in Qdesign

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…).

On Itanium/VMS at least, dates in 2020 appear to be working as expected…

$ quiz

IBM(R) Cognos(R) PowerHouse(R) 4GL  8.40G - QUIZ

(C) Copyright IBM Corp. 1982, 2010

> use date

> define d-days num*8 = days(20200620)

> define d-date date  = date(days(20200620))

> report d-days d-date

> go

02/28/19                 WEST FRASER:   M D S - R8.40gP                PAGE   1

    D-DAYS    D-DATE

      44001  06/20/20

?

Records selected:  0

Lines printed:     3

Pages printed:     1

Don’t know if it helps with the immediate problem, but it does imply that the core system engine is probably OK…

From: powerh-l <powerh-l-bounces at lists.sowder.com <mailto:powerh-l-bounces at lists.sowder.com> > On Behalf Of Robert Deskin
Sent: Wednesday, February 27, 2019 4:04 PM
To: Helen Wellcome <HWellcom at wsboces.org <mailto:HWellcom at wsboces.org> >
Cc: power-l List <powerh-l at lists.sowder.com <mailto:powerh-l at lists.sowder.com> >
Subject: [External] Re: having issues with DAYS function in Qdesign
Importance: High

I honestly can’t remember if there’s a size limit, but even the days in the early 2000s were over 32,768.

Have you tried a simple QUIZ report displaying the value of DAYS(20200630)? Are you using 8-digit dates?

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.

I’m only going by what the manuals say because I no longer have a working version of PowerHouse available to me.

Bob

On Feb 27, 2019, at 1:42 PM, Helen Wellcome <HWellcom at wsboces.org <mailto:HWellcom at wsboces.org> > wrote:

Important .   

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.

We have no problem creating a new 201819 calendar group

06/30/2020     is not converting right for DAYS function.

Please help as this covers MANY areas of our BILLING also.

Helen Wellcome

Western Suffolk BOCES

(631) 595-6887

 <mailto:hwellcom at wsboces.org> hwellcom at wsboces.org

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. -- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list:  <mailto:powerh-l at lists.sowder.com> powerh-l at lists.sowder.com
Subscribe: 'subscribe' in message body to  <mailto:powerh-l-request at lists.sowder.com> powerh-l-request at lists.sowder.com
Unsubscribe: 'unsubscribe <password>' in message body to  <mailto:powerh-l-request at lists.sowder.com> powerh-l-request at lists.sowder.com
 <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> https://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site: <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> lists.sowder.com powerh-l' to your search terms to search the list archive at Google.

-------------EOP--------------- 

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. 

Thank you 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20190228/c1500fd5/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 2422 bytes
Desc: not available
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20190228/c1500fd5/attachment-0002.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 1665 bytes
Desc: not available
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20190228/c1500fd5/attachment-0003.jpg>