on 05-22-2015 5:29 PM
My report has a time field that has values like:
Arrival Time |
---|
1430 |
1245 |
830 |
1600 |
1750 |
1900 |
700 |
1330 |
1250 |
1540 |
1525 |
1750 |
i need to convert it to a time field like 2:30 PM, 1245PM, 8:30 AM etc..
How do i do that?
I tried creating a new variable: =ToDate(FormatNumber([Arrival Time];"#");"yyyyMMdd")
It Gave me an error.
The reason why you were getting the error might be because of the fact that the field is not a date /time field and hence for the same reason, even your DBA might need to write some code to get the format you require.
But you can achieve what you want in web-I or through universe.
Web-I formula below:
=FormatNumber( (If ([Arraival Time]<=1259) Then [Arraival Time] Else [Arraival Time]-1200);"##-:##") +" "+ (If (([Arraival Time]))<1200 Then "AM" Else "PM")
Tested & Works
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Neihi,
The most efficient way would be to create additional Arrival Time objects within the Universe for the desired format required such as GMT, EST, CST, .... This way the users can use the objects required.
Regards,
Ajay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
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.