QDESIGN--Forcing current date into an x(12) field

[Jones Allen]

If that version of Powerhouse has the dateextract function you should be
able to set the field to ascii(dateextract(sysdate,date),8). If it doesn't,
ascii(sysdate,8) should work. 

In each case, that will give you a character string 8 bytes long holding the
date in YYYYMMDD format. That is only 8 characters long and will leave 4
trailing blanls in an x(12) field.

Maybe you need a different format?

-----Original Message-----
From: Al Karman [mailto:Alk@ladyremingtonjewelry.com]
Sent: April 24, 2003 4:23 PM
To: powerh-l@lists.swau.edu
Subject: QDESIGN--Forcing current date into an x(12) field


Happy 24th to the -L....

We're an hp3000/948 running MPE/iX 6.0.0, POW ver. 8.39.C

We're attempting to have an x(12) field be set to current-date for ENTRY
mode inside a QUICK screen.  The field is part of a flat file defined
via the dictionary.

This seems to be lots more complicated than it needs to be....ideas,
thoughts...???

Thanks in Advance!!

 
Al Karman
Director of Information Technology
alk@ladyremingtonjewelry.com


= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe <password>" 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.