i want to use @prompt function in BO Designer

[Eswar75]

hi,

I need to display records in between dates,suppose

Join Date Emp No Emp Name
========= ====== ========
06/07/2004 100 ABC
07/07/2004 200 DEF

here i want to display those two records between dates 06/07/04 and 07/07/2004 ,I am using @prompt function getting error.

How can i use @prompt function in BO designer or else in BO reporting


thank u in advance

 

[jobjoris]

Sample:
TRUNC(A_SALESCALL.CALLDATETIME) BETWEEN (@Prompt('Call Datum from','D','Contact\Contact datum',mono,)) AND (@Prompt('Call Datum untill','D','Contact\Contact datum',mono,))

 

[Eswar75]

that is not working,my database is DB2
so what should i do.........

 

[Eswar75]

i am getting this error

TIMESTAMP(@Prompt('Enter From Date','D',,,),'mm/dd/yyyy') )
[IBM][CLI Driver][DB2/6000] SQL0180N The syntax of the string representation of a datetime value is incorrect. SQLSTATE=22007
:-180

 

[Shoot]

Hi Eswar,

Try this it should work for you...
Join_Date BETWEEN @Prompt('Call Datum from','D','Contact\Contact datum',mono,) AND @Prompt('Call Datum untill','D','Contact\Contact datum',mono,)

Keep Smiling,
Shoot

 

[Eswar75]

Hi Shoot,

unfortunatley that is not working i am using DB2 datebase,
it is giving error like Parse failed:the syntax of the string representation of a datetime value is incorrect.

give me some more

thank u

 

[Shoot]

Hi Eswar,

I guess it is something with the syntax that you are using. If you could provide with an example how you are trying to use it, it would be helpful. I have a DB2 environment and the syntax works fine which is something like this..

@Select(Contact\Contact datum) BETWEEN @Prompt('Call Datum from','D','Contact\Contact datum',mono,) AND @Prompt('Call Datum untill','D','Contact\Contact datum',mono,)

Keep Smiling,
Shoot

 

[jobjoris]

Hi Eswar,

Thing with Date-columns in AS400 DB2 is that these dates are often just Numeric values of 8 digits. Did you try to swap from D to N (or A because your error message is even refering to a string-value) in your @prompt?