I have two dynamic parameter prompts that I want to modify.
One hits a SQL date field and, when the dates appear in the user selection list, then are in the long SQL format with full date and time 2002-06-01 00:00:00. I want it to appear as just the 2008-06-01. Can that be done.
Also, I have a place where the "year" is in a number field -- eg. 2008. But when the parameter is selected, I see 2,008. I'm looking for a way to remove the comma.
Help appreciated -- general principles will probably suffice.
Ridge (in New Joisey)