Skip to Content
0
Former Member
Nov 18, 2008 at 09:40 PM

Formating in a Parameter

22 Views

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)