PromptPageValues

[Kory]

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!

[MFGF]

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.