Display parameter selection in mm/dd/yy OR dd/mm/yy format

[UHsoccer]

I am writing reports for people who are used to the US or European date formats. My date parameter format is set to "mm/dd/yyyy". How can I create a report that displays the parameter choices in "dd/mm/yyyy" format

 

[pgtek]

hi
check this link

http://support.businessobjects.com/...x_ver=&index_lang=&indexq2=&indexq3=&indexq4=

cheers

pgtek

 

[UHsoccer]

Looked at the articles in the link, however..

I need to control in a report whether to display the parameter selection as 'mm/dd'yyyy' for US English users and in 'dd/mm/yyyy" for European users. The reports will be unique for one OR the other.
I expect to need separate reports, because I do not think that I can mix them in a single report at the parameter input level

 

[pgtek]

Hi

Have you tried creating formula to convet your date?

1 for dd/mm/yyyy
2 for mm/dd/yyyy

check with ken web side for more on formula

cheers



pgtek

 

[pgtek]

check this thread

thread767-774846


cheers



pgtek

 

[UHsoccer]

I have no problem converting dates between the various formats.

When DEFINING the parameter for user input, I cannot find an option to specify which date format the parameter is to be presented in

 

[pgtek]

hi looks at this one

thread149-781953

cheers

pgtek

 

[pgtek]

hi
I see your problem the choice of format us or european

you could use 2 parameter to resolve this issue

1. parameter is Calendar Selection as string and have user pick either US or European

2. parameter would be to have user input date format as string

11/05/2003 or 05/12/2003

Create 2 formala to convert the dates 1 to @US nad the other to {@european}

in your formula Date conversion you will need both parameter
in the option

ex:
if
{?Calendar Selection} = "US"
then
{?Dateformat} = {@US}
else
if
{?Calendar Selection} = "European"
the
{?Date Format} = {@european}

hope this helps

cheers





pgtek

 

[UHsoccer]

So that means that the user will not NOT be able to select from a calendar. I would have to define that entry as a string and then post process the string to a date.
Correct?

 

[pgtek]

Hi
that is correct
in the
date format you can have this
as input type

dd/mm/yyyy or mm/dd/yyyy

cheers





pgtek