QTP and SYSDATE

[Ron Olenic]

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