QTP and SYSDATE

[DAVID MORANKO]

Another thought...

If you indeed are working with AMISYS, why Powerhouse 5? If you are running an even close to current AMISYS version, you should be on Powerhouse 8, or at minimum 7.



~~~~~~~~~~~~~~~
David M. Moranko
Programmer Analyst II
The Wellness Plan
Info. Svcs.
Direct:  313.202.8788
Fax:      313.202.8603


>>> "Richard S. French" <rfrench@axiom-systems.com> 10/16/01 04:14PM >>>

Thanks, but I can't get this to work.
DEFINE TEM-DATE CHAR*8 = ASCII(SYSDATE,8)
I get this message. *E* Type of TEMP-DATE incompatible with expected type.
If I access the dataset and show items the YMDTRANS field shows as NUM,
although the source for the dictionary has it as freeform.

 -----Original Message-----
From: 	Ron Olenic [mailto:ROlenic@spectra-inc.com] 
Sent:	Tuesday, October 16, 2001 12:59 PM
To:	'Richard S. French'; powerh-l@lists.swau.edu 
Subject:	RE: QTP and SYSDATE

My guess would be that the sysdate is being returned in binary format.  The
freeform data type is essentially a character field.  Do an ASCII conversion
of the sysdate, and populate the field using the ASCII value of the date
field.  Insure that you force an 8 character output for consistency.

ascii(sysdate,8)

Ron Olenic

>  -----Original Message-----
> From: 	Richard S. French [mailto:rfrench@axiom-systems.com] 
> Sent:	Tuesday, October 16, 2001 12:17 PM
> To:	powerh-l@lists.swau.edu 
> Subject:	QTP and SYSDATE
>
> Help! I am using QTP version 5.09.02 and trying to update a field in a
> dataset called YMDTRANS. This field is FREEFORM 8 per the dictionary. How
> can I use SYSDATE to return today's date to this field such as 20011016? I
> keep getting 1011016 or 218. Thanks.
>
> Richard S. French
> Professional, Academy for Healthcare Management
>
> Axiom Systems, Inc.
> 'The Managed Care Systems Experts'
> 20300 Century Blvd - Suite 120
> Germantown, MD 20874-1110
>
> 301-840-9165 x 224 Direct
> 707-598-3983           E-Fax
> 301-840-3861           Main
> 301-840-3873           Fax
>
>
> mailto:rfrench@axiom-systems.com 
> http://www.axiom-systems.com/ 
>
>
>


= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu 
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu 
Unsubscribe: "unsubscribe" in message body to powerh-l-request@lists.swau.edu 
http://lists.swau.edu/mailman/listinfo/powerh-l 
This list is closed, thus to post to the list you must be a subscriber.