Larry;

The VB manual seems to indicate that what you're converting need to be a
string.

HTH,
Don Harrington
Sr. Systems Analyst
Facilities Applications Support
Shared Services Group
The Boeing Company
P.O. Box 3707 M/C 2R-32  NEW!
Seattle, WA  98124-2207
(v) 206-544-5679  NEW!  (f) 206-544-5788  NEW! (p) 206-797-6360

The opinions expressed in this e-mail reflect those of the sender.  They do
not necessarily reflect the opinions of The Boeing Company unless
specifically stated otherwise.



-----Original Message-----
From: Larry Barnes [mailto:[log in to unmask]]
Sent: Thursday, April 04, 2002 1:17 PM
To: [log in to unmask]
Subject: [HP3000-L] Reflection Date Conversion


I'm writing a VB script in Reflection and I'm having trouble converting a
number back into a date once I've modified it using the InputBox statement.

Here's what I've got

            req_date = Format(Now(), "YYMMDD")
            hpfile = InputBox("Enter the DATE (yymmdd) of file to use? ",
"HP Transfer File Name", req_date)

        the results is 020404

        I can modify this date using the inputbox.

        Once this is done I need to convert the variable (hpfile) back into
a date for calculation purposes.  I've tested "FORMAT, CDATE" and other
functions I can't remember and I'm not having any luck.  Can someone out
there point me in the right direction?


Thanks in advance,

Larry <I'm going to lunch to clear my thoughts> Barnes

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *