[External] Re: having issues with DAYS function in Qdesign
Pierre Bouthillette
pierre.bouthillette at gmail.com
Thu Feb 28 08:24:06 CST 2019
Hi Helen
pdl setup ?
if default century specified ?
qshow
show all
Created: On 2019/02/26 By PDL 8.43.G
-- Date Options --
Century Included?: Yes Default Century: 20
Date Picture: YYYY/MM/DD Input Century: not specified
Nullseparator: not specified Allow Century: not specified
Force Century: not specified Date Parm Inherit: No
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
On Thu, Feb 28, 2019 at 9:11 AM Helen Wellcome <HWellcom at wsboces.org> wrote:
> 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> * On Behalf Of *Robert
> Deskin
> *Sent:* Wednesday, February 27, 2019 4:04 PM
> *To:* Helen Wellcome <HWellcom at wsboces.org>
> *Cc:* power-l List <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> 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
>
> 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: powerh-l at lists.sowder.com
> Subscribe: 'subscribe' in message body to
> powerh-l-request at lists.sowder.com
> Unsubscribe: 'unsubscribe <password>' in message body to
> powerh-l-request at lists.sowder.com
> https://lists.sowder.com/mailman/listinfo/powerh-l
> <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>
> This list is closed, thus to post to the list you must be a subscriber.
> Add 'site:lists.sowder.com
> <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>
> 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
> --
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l at lists.sowder.com
> Subscribe: 'subscribe' in message body to
> powerh-l-request at lists.sowder.com
> Unsubscribe: 'unsubscribe <password>' in message body to
> powerh-l-request at lists.sowder.com
> 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:lists.sowder.com powerh-l' to your search terms to search the
> list archive at Google.
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20190228/23ce6678/attachment-0001.html>
More information about the powerh-l
mailing list