Data conversion problems

[pickerij@norbord.com]

Colin:

In your define you are comparing an item which is defined as a date in   
the dictionary with a value which is not a valid date - i.e. 500000 is   
not a date -- change it to 500101 and it should work.

John Pickering
JWP Systems Inc
Toronto

 -----Original Message-----
From: cglass@mlcc.mb.ca
Sent: Friday, April 24, 1998 3:53 PM
To: powerh-l@lists.swau.edu
Subject: Data conversion problems

 << File: ENVELOPE.TXT >>
 --------------------------------------------------------------------------  
 --
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.