QTP and SYSDATE

[DAVID MORANKO]

Richard,

I'm guessing if you're using Powerhouse and work in managed care, you're working with AMISYS??

You should be able to do the following on any YMDTRANS field (If, infact, you are trying to use QTP to update that field) in an AMISYS database:

item YMDTRANS final (or INITIAL) SYSDATE

Can you report SYSDATE in QUIZ? What does it look like? Maybe you have a system problem. 

~~~~~~~~~~~~~~~
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.