I built a date/time field and I am trying to compare it to a date defined in FOCUS.
I am getting errors!?!?

-*
 -SET &BEG1 = '20081201';
 -SET &END1 = '20081231';
 -*
 -SET &BEGDT = EDIT(20081201,'9999/99/99') |''| '00:00:00';
 -SET &ENDDT = EDIT(20081231,'9999/99/99') |''| '23:59:59';
 -*
 -TYPE 2008/12/01 00:00:00 . . . . . . 2008/12/31 23:59:59
 2008/12/01 00:00:00 . . . . . . 2008/12/31 23:59:59
 -*
 -*
 JOIN CLEAR *
-* Here, I have a WHOLE BUNCH of JOINs
 -RUN
 -*
 TABLE FILE WHATEVER
 BY RESULT_DATE
 WHERE RESULT_DATE GE '2008/12/01 00:00:00' LE '2008/12/31 23:59:59';
 IF RECORDLIMIT EQ 15
 END
-RUN
 -EXIT
 0 ERROR AT OR NEAR LINE     33  IN PROCEDURE ADHOCRQ FOCEXEC *
 (FOC015) THE TEST VALUE IS LONGER THAN THE FIELD FORMAT LENGTH: 2008/12/01
 00:00:00
 0 ERROR AT OR NEAR LINE     33  IN PROCEDURE ADHOCRQ FOCEXEC *
 (FOC280) COMPARISON BETWEEN COMPUTATIONAL AND ALPHA VALUES IS NOT ALLOWED
 (FOC009) INCOMPLETE REQUEST STATEMENT
 BYPASSING TO END OF COMMAND
 -*
 -SET &BEG1 = '20081201';
 -SET &END1 = '20081231';
 -*
 -SET &BEGDT = EDIT(20081201,'9999/99/99') |''| '00:00:00';
 -SET &ENDDT = EDIT(20081231,'9999/99/99') |''| '23:59:59';
 -*
 -TYPE 2008/12/01 00:00:00 . . . . . . 2008/12/31 23:59:59
 2008/12/01 00:00:00 . . . . . . 2008/12/31 23:59:59
 -*
 -*
 JOIN CLEAR *
-* Here, I have a WHOLE BUNCH of JOINs
 -RUN
 -*
 TABLE FILE WHATEVER
 BY RESULT_DATE
 WHERE RESULT_DATE GE '2008/12/01 00:00:00' LE '2008/12/31 23:59:59';
 IF RECORDLIMIT EQ 15
 END
-RUN
 -EXIT
 0 ERROR AT OR NEAR LINE     33  IN PROCEDURE ADHOCRQ FOCEXEC *
 (FOC015) THE TEST VALUE IS LONGER THAN THE FIELD FORMAT LENGTH: 2008/12/01
 00:00:00
 0 ERROR AT OR NEAR LINE     33  IN PROCEDURE ADHOCRQ FOCEXEC *
 (FOC280) COMPARISON BETWEEN COMPUTATIONAL AND ALPHA VALUES IS NOT ALLOWED
 (FOC009) INCOMPLETE REQUEST STATEMENT
 BYPASSING TO END OF COMMAND

Below is what just a report of the RESULT_DATE field.

-*
 TABLE FILE WHATEVER
 BY RESULT_DATE
 IF RECORDLIMIT EQ 3 
 END
-RUN
....
Here is a little report:
RESULT_DATE 
2000/03/28 00:00:00 
2000/03/29 00:00:00 
2000/03/30 00:00:00 

In the WHATEVER Master File, RESULT_DATE is defined:
FIELDNAME=RESULT_DATE, ALIAS=RESULT_DATE, USAGE=HYYMDS,
ACTUAL=HYYMDS, MISSING=ON, $

Any Ideas???

This message has been edited. Last edited by: Kerry,

If you do not need the time part in the date field in your database (Result_Date) try to remove it.

How

Change the master file description or create an new defined field.

NEWDATE/YYMD=HDATE(RESULT_DATE,'YYMD');

Now you can select on this more simple field.

1)

WHERE RESULT_DATE GE '2008/12/01 00:00:00' LE '2008/12/31 23:59:59';

is not a valid shortcut for FROM-TO or GE and LE selection

2) Because the date-time field in WHATEVER is an HYYMDS field, your filter should look like this:

WHERE RESULT_DATE GE DT('2008/12/01 00:00:00') AND RESULT_DATE LE DT('2008/12/31 23:59:59');

You may need to use - instead of /, depending on the DBMS of the table):

WHERE RESULT_DATE GE DT('2008-12-01 00:00:00') AND RESULT_DATE LE DT('2008-12-31 23:59:59');

PROBLEM SOLVED

How Tom
was one of our suggestion of any help?

quote:

WHERE RESULT_DATE GE DT('2008/12/01 00:00:00') AND RESULT_DATE LE DT('2008/12/31 23:59:59');

Thank you both for your suggestions. They are
both workable, but I liked using the true
date/time field, and I have always LOVED coding in Dialogue Manager!

Thanks!