date format different between infoview and FC

[system]

Hi everybody,

When we refresh a report in Infoview with the prompt “date of creation” the date have the format MM/DD/YYYY whereas in the universe it’s dd/mm/yyy.

What can we do for having always the dd/mm/yyyy?

Nota : OS : english
SGDB : SQL Server english

Thanks
Chris

---

Maitre B (BOB member since 2004-09-02)

[system]

Hi Chris,

From my experience 6.5 Enterprise Server date format dependencies are as follows:

DATE FORMAT OF USER PROMPTS
The date format set for the entry USER_INPUT_DATE_FORMAT in the .prm file under the type of DB being connected to in the location :\Business Objects\BusinessObjects Enterprise 6\dataAccess\

DATE FORMAT OF WEB SERVER

1. Date format settings in the Regional Options on the web server
2. The date format set for the entry ID_DATEFORMAT in the following resource & locale files (This is what is displayed on your infoview report list):
   a. resource_en.msg
   b. locale_en.msg
   c. locale_en_XX.msg

I have customised these files for my installation to YYYY/MM/DD HH:MM:SS since my requirement is for date in this format & the web server locale setting is US.

I hope this helps

cheers

---

Sanil (BOB member since 2005-09-26)

[system]

Thanks but,

I have modified the input date format in my prm file.
I have passed it to dd/mm/yyyy.
and in my infoview I had date in prompt in french.
I haven’t do like you suggest.
All was perfect.

But yesterday, i have upgrade my server to 6.5.2. and now my problem is come back!!!

I’m lost !
Could you help me to find a way to fixed my problem ?

Regards
Chris

---

Maitre B (BOB member since 2004-09-02)

[system]

Probably the patch has upgraded your prm file. Check if that is the case.

cheers

---

Sanil (BOB member since 2005-09-26)

[system]

Yep, patching with 6.5.2 SP2 overwrites config files, deletes skin-directories en entries in config files

And still Webi 6.5.2 can’t handle properly a different number format… Englisch Webi, with Dutch number format, start patching the config files

---

Frans (BOB member since 2005-10-06)

[system]

Hi,

This is my favourite topic!

See here:

120×120 10.4 KB

Thanks for your reponse: When you add this to your object in the universe {Date_Field = to_date(@prompt(‘Your message’,‘A’,‘LOV’,mono,free),“dd/mm/yyyy”) } did you add it to the WHERE section? I tried and it says, Parse failed Invalid Definition. Did you keep the TYPE as Date or change it to CHAR? Do you have just the object name in the SELECT section, or does it have to have something changed as well? Thanks, Jason rowlajsrowdy (BOB member since 2005-04-01)

---

SteveR (BOB member since 2004-08-27)

[system]

Hi, absolutely, the configuration file have benn updated.

I have put dd/mm/yyyy in the INPUT_DATE_FORMAT
and it’s OK now.

Thanks to everybody.
Regards

---

Maitre B (BOB member since 2004-09-02)

[system]

But the best solution for having date in french format without modify prm file is:

• Change the date format (English UK) in regional settings
• And change the date format (English UK) in Console Administration (restart webi server)

Regards

---

Maitre B (BOB member since 2004-09-02)

[system]

Like the topic starter I’m also facing troubles with date prompts.

I’ve got a FC report with a date prompt which is in a dd-mm-yyyy format.

When I want to view it in webi and I fill out the prompts it only will work if I give a mm-dd-yyyy answer…

I’ve changed the following settings, to try to get webi to accept a dd-mm-yyyy prompt answer…

But with no luck so far

• Webi server OS (win 2003 server) regional setting = English (US)
• Administration Console = Englisch (US)
• Oracle.prm (database)= USER_INPUT_DATE_FORMAT">‘dd-MM-yyyy HH:mm:ss’ and DATABASE_DATE_FORMAT">DD-MM-YYYY HH24:MI:SS
• Local_en.msg:
  ID_DATEFORMAT = dd/MM/yyyy hh:mm:ss aa
  -locale_en_US.msg:
  ID_DATEFORMAT = dd/MM/yyyy hh:mm:ss aa
• Resource_en.msg:
  ID_DATEFORMAT = dd/MM/yyyy hh:mm:ss aa
• objectformat.xml:
  [Adti]" TEMPLATE=“d’/‘M’/‘yyyy h’:‘mm’:'ss a”

Is there anything I forgot???

ps
using Bo 6.5.2

---

Tiny (BOB member since 2004-11-10)

[system]

@Tiny

Like the topic starter I’m also facing troubles with date prompts.

I’ve got a FC report with a date prompt which is in a dd-mm-yyyy format.

When I want to view it in webi and I fill out the prompts it only will work if I give a mm-dd-yyyy answer…

I’ve changed the following settings, to try to get webi to accept a dd-mm-yyyy prompt answer…

But with no luck so far

• Webi server OS (win 2003 server) regional setting = English (US)
• Administration Console = Englisch (US)

Hi
You must choose English UK in Console Administration
and Webi Server OS. Not US.

Don’t touch to your prm files.

Regards
Chris

---

Maitre B (BOB member since 2004-09-02)

[system]

@Maitre B

You must choose English UK in Console Administration
and Webi Server OS. Not US.

Don’t touch to your prm files.

Regards
Chris

So change Console admin to English UK
and make sure regional setting from OS (webi server) are also set to English UK? and that’s it?

Can’t believe this!

---

Tiny (BOB member since 2004-11-10)

[system]

hahahahahaha
your right MaitreB!!!

unbelievable!
it works
ps
But I don’t know if my changes for all the other files which I mentioned where necessary yes or no???

---

Tiny (BOB member since 2004-11-10)

[system]

Hi Everyone,

Seems to me that this is becomming a bit of a common issue with Bobblers!

I have also changed the .prm’s, and checked the OS date settings, but to no avail, …but not the admin console yet - could anyone let me know how to do this? (Dummy steps please - as I am not very familar with the console yet!!)

Thanks in (frustrated and hopeful) advance!

Steve

---

snakeboy (BOB member since 2003-12-02)

[system]

1. On the Webi Server Start Program Files-Business Objects- Admin Console

2. Log in as GS

3. In Locale change from English US to UK

4. Click Apply

5. Logout

6. Restart Webi (not sure if you need to but I always do)

---

irish_stan (BOB member since 2003-05-13)

[system]

Thanks Stan,

I have tried that, and it still hasnt worked… I checked the Console as well once the server had restarted to check that the changes had taken effect, and they had…

any other ideas?

(the way that I am checking is by parsing a predefined condition that has the input date set to DD/MM/YY ie it Arrival date between CAST(‘27.12.2003’ as DATETIME) and CAST(‘31.12.2004’ as DATETIME)), this returns the error message…

Exception: DBD, [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.State: 22007

Thanks for your help,

Steve

---

snakeboy (BOB member since 2003-12-02)

[system]

Hmm - I have also searched for the .msg files on my local pc, and found nothing… Is this to be expected?

…on the server I found them, but I dont know how to change them - as they are not normal network files - any advice on changing the following files? - Anything is worth a try!!!

• Local_en.msg:
  ID_DATEFORMAT = dd/MM/yyyy hh:mm:ss aa
  -locale_en_US.msg:
  ID_DATEFORMAT = dd/MM/yyyy hh:mm:ss aa
• Resource_en.msg:
  ID_DATEFORMAT = dd/MM/yyyy hh:mm:ss aa
• objectformat.xml:
  [Adti]" TEMPLATE=“d’/‘M’/‘yyyy h’:‘mm’:'ss a”

Thanks again,

Steve

---

snakeboy (BOB member since 2003-12-02)

[system]

Ahhhhhhh - Have found the problem - in Data Source (ODBC) settings, config options the ‘Language of SQL Server system messages to:’ option was set to English… I thought that this was correct, until I found out that there is actually a “British English” option - which is dd/mm/yyy format, whilst ‘English’ is actually mm/dd/yyy format…

Never would have noticed that!

Changed it on my local pc, the server and the DB; All sorted now.

Steve

---

snakeboy (BOB member since 2003-12-02)

[system]

Same issue with Webi 65 SP2 MHF7 On unix Solaris. We have sybase database. Changed in

webi652\dataAccess\RDBMS\connectionServer\sybase

the sybase.prm and sybase11.prm

as ‘dd/mm/yyyy’ in order to have day before month in prompts.

I have regenerated bomain.key, checked in MyWebiEnv.sh that

NLS_DATE_FORMAT=“DD-MM-YYYY HH24:MI:SS”;export NLS_DATE_FORMAT is ok

TMP_LG=en_US
NLS_LANG=“AMERICAN_AMERICA.WE8ISO8859P15”; export NLS_LANG

but in date prompt, i have still mm/dd/yyyy entries !

So what ??
If someone has an idea…
Thank you for advance
Bernard

---

bernard timbal (BOB member since 2003-05-26)

[system]

Hi Bernard,

I have raised Case 302638225 with Business Objects, and they are looking into creating a patch for this ‘feature’!!!

Regards,

Steve

---

snakeboy (BOB member since 2003-12-02)

[system]

do you want to say it is a bug and it should display in my prompt in the right format i set in the prm file ?

---

bernard timbal (BOB member since 2003-05-26)