QTP and SYSDATE

[Richard S. French]

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/
>
>
>