HP3000-L Archives

April 2002, Week 1

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Larry Barnes <[log in to unmask]>
Reply To:
Larry Barnes <[log in to unmask]>
Date:
Thu, 4 Apr 2002 16:17:11 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (26 lines)
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 *

ATOM RSS1 RSS2