Data conversion problems

[Mary E. Cunningham]

Colin,

If you isolate the data conversion to the questionable dates you will 
probably find that the dates are January 1, 2, 3, or 4. I don't know why - 
but that is what we have discovered so far.

Mary Cunningham
Creative Computing, Inc.

-----Original Message-----
From:	COLIN GLASS [SMTP:cglass@mlcc.mb.ca]
Sent:	Friday, April 24, 1998 4:52 PM
To:	powerh-l@lists.swau.edu
Subject:	Data conversion problems

Using QTP 7.09 on the HP3000 using a TurboImage database, I am having
trouble with data conversion errors.  I have found that the data conversion
errors occur in my select statement, but don't understand why and don't
know how to resolve it.  Here is the portion of the program I'm having
trouble with:

TEMP   T-TRANS-DTE ZONED SIZE 8
  ITEM T-TRANS-DTE           = TRANS-DTE OF R-ADJ-DTLS          &
                 IF 8 = SIZE(ASCII(TRANS-DTE OF R-ADJ-DTLS))    &
               ELSE ADDCENTURY(TRANS-DTE OF R-ADJ-DTLS,20)      &
                 IF TRANS-DTE OF R-ADJ-DTLS < 500000            &
               ELSE ADDCENTURY(TRANS-DTE OF R-ADJ-DTLS,19)

TEMP   T-DTE-MONTH ZONED SIZE 8
  ITEM T-DTE-MONTH    = DTE-MONTHLY OF S-DATE-CTRL      &
                 IF 8 = SIZE(ASCII(DTE-MONTHLY OF S-DATE-CTRL)) &
       ELSE ADDCENTURY(DTE-MONTHLY OF S-DATE-CTRL,20) &
                 IF DTE-MONTHLY OF S-DATE-CTRL < 500000         &
               ELSE ADDCENTURY(DTE-MONTHLY OF S-DATE-CTRL,19)

SELECT IF T-TRANS-DTE GE T-DTE-MONTH


TRANS-DTE is defined in the dictionary as a date with century excluded and
DTE-MONTHLY is defined as a numeric 6.

Can anyone give me some help please?

Thanks

Colin Glass
Manitoba Liquor Control Commission
Winnipeg, Manitoba, Canada
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.