I am trying to do a drill down on a Date field.

The procedure1 is connected to procedure2 and it passes the a date.

more specifically procedure1 passes "DT(mm/dd/yyy)"

the procedure2 is looking for "mm/dd/yyyy" but it recieves "DT(mm/dd/yyyy)" from procdure1

Then it gives me this error

0 ERROR AT OR NEAR LINE 40 IN PROCEDURE futuresellchanges4
(FOC177) INVALID DATE CONSTANT: DT(05/23/2011
(FOC009) INCOMPLETE REQUEST STATEMENT
BYPASSING TO END OF COMMAND



I hope someone understands and is able to help!
Thank you so much!



it is very frustrating and i can't figure out why it can't just pass the date

This message has been edited. Last edited by: Charles Richards,

Please show us the drilldown code.

procedure 1 & 2 have the same data


procedure 1 passes parameters to procedure 2 via drilldown parameter

CODE:

WHERE SELLEFFECTIVEDATE EQ DT(&SDATE);


procedure 2 recieves parameters from procedure 1 via the drilldown parameter

procedure 2 has this where statement



SELLEFFECTIVEDATE EQ DT(&SDATE)


I still get the error

0 ERROR AT OR NEAR LINE 40 IN PROCEDURE futuresellchanges4
(FOC177) INVALID DATE CONSTANT: DT(05/23/2011
(FOC009) INCOMPLETE REQUEST STATEMENT
BYPASSING TO END OF COMMAND



and if i change the format
from MDYY to MDY


0 ERROR AT OR NEAR LINE 40 IN PROCEDURE futuresellchanges4
(FOC177) INVALID DATE CONSTANT: DT(05/23/11
(FOC009) INCOMPLETE REQUEST STATEMENT
BYPASSING TO END OF COMMAND



Please Help!

The WebFOCUS stylesheet in your fex has code that generates the drilldown - that's what we need to see.

E.g.:

TYPE=DATA, COLUMN=STORE_NAME, FOCEXEC=TEST (STORE_NAME=STORE_NAME), $

I figured out what it was

when you use the GUI to add a where statement involving dates it adds the "DT()" around the data. Then when you use the drilldown GUI to pass a date it also puts a "DT()" around the date ending up with one to many "DT()"

Solution

In the where statement I deleted the "DT()" around the parameter DT(&TEST) leaving just &TEST