tsquare1975
IS-IT--Management
- Apr 10, 2012
- 21
Dear All,
I am trying to get user input for date (getting prompt to enter date) and have following satement with left outer join in my query
(
and cast(o.expdate as varchar) = '{?enterdate}'
)
but when i use single qoutes in '{?enterdate}' error found (faild to convert text data type to numeric) and without single qoutes i get syntax error. at last i use above said statement to conver expdate (which is numeric/decimal) into varchar .... but still i can't get any prompt. Plz guide how can i get my desired result
Note: enterdate is created param in crystal and is numeric. In Crystal 10
Thanks
I am trying to get user input for date (getting prompt to enter date) and have following satement with left outer join in my query
(
and cast(o.expdate as varchar) = '{?enterdate}'
)
but when i use single qoutes in '{?enterdate}' error found (faild to convert text data type to numeric) and without single qoutes i get syntax error. at last i use above said statement to conver expdate (which is numeric/decimal) into varchar .... but still i can't get any prompt. Plz guide how can i get my desired result
Note: enterdate is created param in crystal and is numeric. In Crystal 10
Thanks