SET VAR vdatevar DATE = .vdate
Okay, suppose that I'm using a DIALOG to acquire user-input of a date-string, MM/DD/CCYY.
Now, I want to convert this string into a DATE-type, fm its DIALOG-implied type of TEXT.
As I don't see this type of conversion function "built in",
I was wondering what y'all might have to say to advise me.
Here are some of my thoughts on the topic, assuming a TEXT value of 08/17/1991
f/var named vDateText (not a random value, our anniversary date, umm', if I recall correctly) :
- I could :
SET VAR vDateTextNew TEXT = ( CHAR(34) + .vDateText DATE + CHAR(34) )
then
SET VAR vDateType DATE = &vDateTextNew
but, I'm having trouble getting that second double-quote to suffix properly
(Yep', Bill, because you once asked, I'm still using DBL-Quotes, )
(but let's chat about that later, unless it's of issue here ... )
- I also could create 3 INT's
SET VAR vIMON INT = (INT(SGET(.vCutoffDateTXT,2,1)))
SET VAR vIDAY INT = (INT(SGET(.vCutoffDateTXT,2,4)))
SET VAR vIYR4 INT = (INT(SGET(.vCutoffDateTXT,4,7)))
then
SET VAR vDateType = (RDATE(.vIMON, .vIDAY, vIYR4))
- I know that I could use a form w/a DATE-type variable,
or even a DATE field fm a DUMMY table, so I wouldn't have to fool w/this,
but I've chosen not to do that, at least f/now.
DATE SETTINGS ARE :
FORMAT MM/DD/YYYY
SEQUENCE MMDDYYYY
CENTURY 30
DEFAULT 19
TIA,
Steve in Memphis
Manager, DairyPak Business Systems
Blue Ridge Paper Products, Inc.
40 Lindeman Drive
Trumbull, CT 06611
(203) 673-2231
[EMAIL PROTECTED]
[EMAIL PROTECTED]
