Changing default date format to UK i.e DD/MM/YYYY

building reports webintelligence
1

Dear All,

We are on BO4.0

We have a user input on Date range (i.e from & to date). Currently it accepts date in the format M/d/yyyy h:mm:ss a.

But this need to be displayed in DD/MM/YYYY. If possible, the user prompt also should be changed to DD/MM/YYY format.

Any help would be highly appreciated.

Many Thanks,
Pavan

PavanRaj_S (BOB member since 2013-02-07)

2

Any inputs on this.

FYI i have already tried below formulas & its not working as desired:

=FormatDate(ToDate(Substr(UserResponse(“Enter Arrival Date”);1;10);“m/d/yyyy”);“dd/mm/yyyy”)+";"+FormatDate(ToDate(Substr(UserResponse(“Enter Arrival Date”);21;10);“m/d/yyyy”);“dd/mm/yyyy”)

Also

formatdate(todate(userresponse(“DateRange”);“m/d/yy”);“dd/mm/yyy”)

Thanks,
Pavan

PavanRaj_S (BOB member since 2013-02-07)

3

We had the same sort of problem when we went to XI - your users need to ensure that the locale used for the PC (control panel) is UK, and also ensure that their Webi locale options are both set to ‘English (United Kingdom)’ and that the ‘Use my formatting locale to format the data’ radio button is checked.

Maddye :uk: (BOB member since 2009-01-09)

4

Please note that these are report level formula which will never work for this.
Edit, apologies, there are two issues one for the prompt and one for the report level format, I’ll get my coat :mrgreen: .

Mak 1 :uk: (BOB member since 2005-01-06)

5

Hi Pavan,
Did you try something like below?

=FormatDate(ToDate(UserResponse(“Enter Arrival Date”); “M/d/yyyy h:mm:ss a”); “dd/MM/yyyy”)

Note: m is for Minutes and M is for Months.

praveenmaddi (BOB member since 2011-05-10)