cancel
Showing results for 
Search instead for 
Did you mean: 

Hoe to change the date format

Former Member
0 Kudos

Hi friends,

Hope all are good,

I have one issue in date format. In my database i have the date format like this. yyyy-mm-dd h:mm:ss.0000 like this, it contains all hours and minutes,seconds information. But when i use this date in the webi, it display like this mm-dd-yy, then i changed the format in universe, then it display like this yyyy-mm-dd 00:00:00:.0000, instead of hour miutes seconds it display's only zeros.

The same date i used as a filter in the report as well. is there any way to handle this. Otherwise how can i change the date format.Becoz based on the hour minute second only my client needs to filter the data.

Plz advise me

Thanks lot,

Reagdrs,

-B-

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

First in universe designer

create a object like

Date = convert(datetime,date_submitted,120)as Date

use this formula in report designer

=FormatDate([Date];"dd-mmm-yyyy hh:mm")

hope it will work

Former Member
0 Kudos

Thank you for your reply.

How can i change in the filter(Calendar in report) i need format like this yyyy-mm-dd h:mm:ss.0000 in calendar

Thanks lot,

Regards,

-B-

Former Member
0 Kudos

you can use this

in universe

Object date = convert(datetime,date_submitted,120)as Date

May be it can help you.