QTP and SYSDATE

[Glenn Waters]

Richard,

I'm not real familiar with FREEFORM numbers, but the book says

"Powerhouse stores items of FREEFORM datatype as a string of characters 
that form a number". Perhaps this will work for you...


define sysdate-char char*8 = ascii(sysdate,8)

other qtp stuff you might need....


item YMDTRANS final sysdate-char
(you might have to   item YMDTRANS final nconvert(sysdate-char) if it 
complains about it being the wrong type.)

hope this helps,

Glenn



At 12:16 PM 10/16/2001 -0400, you wrote:
>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 <mailto:rfrench@axiom-systems.com>
>http://www.axiom-systems.com/ <http://www.axiom-systems.com/>
>
>
>