on 10-21-2008 7:18 AM
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-
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
you can use this
in universe
Object date = convert(datetime,date_submitted,120)as Date
May be it can help you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.