I created a report with a prompt page. I used the cast_timestamp function to convert a char field to a date.
All is well with that, however on the prompt page I have a drop down list. The drop down list does not have the date converted, it displays as 20060817 - Page 1 (with the timestamp function displays August 17, 2006. I noticed there are two queries in the report. I guess using a function creates another query. If I convert the shipping date field to a date field in query 2, the report displays nothing. What do I need to do to convert the values in the drop down list and get results when I run the report? Static display is not an option.
Thanks In Advance!
I think the problem is that you are filtering on the char column that you want displaying as a date.
The second query is added to your report because you are using a value prompt, not because you are calling a function. The value prompt needs to display a list of values from the database, and the second query is the mechanism it uses to retrieve the list.
Modify the second query to contain the same shipping date item a second time (with the second shipping date item renamed to something like Shipping Date Display). Use your cast_timestamp function on this new data item, but leave the original as a char.
Finally modify the prompt on the prompt page to use the char shipping date ('use value' property), but display the date shipping date ('display value' property).
Hope that helps,
MF.