on 05-30-2011 1:30 PM
Hi all,
"Date" column displays date in dd.mm.yy format when report in BO is generated; however, date in Oracle table is saved in dd.mm.yyyy format (and it's correct). How do I display the same correct format in BO report?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
Right click the Date column.
Select "Format Number"
Date/Time -> Custom ->
Type manually as dd.mm.yyyy against Date/Time Text box
Click "Add" and then OK.
Regards,
Vamsee
Don't use lower case m's because it means minutes. Use it like this:
dd.MM.yyyy
with uppercase M
Edited by: PadawanGirl on May 31, 2011 10:02 PM
Hi,
You can also use formula FormatDate. Syntax is :-
FormatDate(CurrentDate();"dd/MM/yyyy")
Hope it helps.
Prakash
Or you can even define the formatting down in the universe. Right click the dimension and select object Format... and enter the desired date.
DG
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.