Date formats in french

building reports webintelligence
1

Hi,
I am working on XI R2,I need date formats on the report (dd/MM/yyyy) in french.
Can u please suggest me some formats in french.
Do i need to update some details on the Server???

mdee (BOB member since 2009-11-04)

2

Um - isn’t dd/MM/yyyy the same in any language?

What are you trying to do?

debbie

Debbie :uk: (BOB member since 2005-03-01)

3

Hi Debbie,
I have date format as dd/mm/yyyy in my database how do convert it in french…i.e 12-Mars-2010

mdee (BOB member since 2009-11-04)

4

Quickest in webi would probably be to create a variable:


=If(MonthNumberOfYear([Date_object])=1;"Janvier";
If(MonthNumberOfYear([Date_object])=2;"Fevrier"))

etc. You might have to stitch together two variables as I’m not sure how far down you can nest if statements in webi

Debbie

Debbie :uk: (BOB member since 2005-03-01)

5

I don’t know in which language you’re supposed to work, but BO by default adapts itself to the browser’s language. You can change to French in your preferences.

If you want to force the date whatever the language, the format is dd/MM/yyyy. You cannot have French month names (“12 mars 2010”, without capitals or hyphen) without creating a function.

KFonMurphi :fr: (BOB member since 2007-10-16)