having issues with DAYS function in Qdesign

[Helen Wellcome]

To clarify .

Our fields are date century included.
Our entry screens   are mm/dd/yy


When keying in a date on a screen with year 2018;   the result is 2018
                                                                                           2019                              2019
                                                                                           2020                              1920
                                                                                           2021                              1921

 There must be a bug in the logic of the screen system.

helen

From: Helen Wellcome
Sent: Thursday, February 28, 2019 8:47 AM
To: 'Robert Deskin'
Cc: power-l List
Subject: RE: having issues with DAYS function in Qdesign

Here is what I sent one of the respondents yesterday
I made a quick qdesign

Its not just one screen entry. A user called the other day . I checked this morning after figuring the century problem and that screen too created a next_bill_date as 19200131.   And then user cant enter calendar for next month because it tried 19200131 instead of 20200131 when keying 013120 on the screen.

All our screens are date century included field and key in mm/dd/yy

Helen




From: Robert Deskin [mailto:bob.deskin at me.com]
Sent: Wednesday, February 27, 2019 5:04 PM
To: Helen Wellcome
Cc: power-l List
Subject: 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
hwellcom at wsboces.org<mailto: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<mailto:powerh-l at lists.sowder.com>
Subscribe: 'subscribe' in message body to powerh-l-request at lists.sowder.com<mailto:powerh-l-request at lists.sowder.com>
Unsubscribe: 'unsubscribe <password>' in message body to powerh-l-request at lists.sowder.com<mailto: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<http://lists.sowder.com/> powerh-l' to your search terms to search the list archive at Google.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20190228/d20a0c7f/attachment-0001.html>