Hello,
I'm using Cognos 10.1.1 with relational data (Informix). I was hoping to find a simple solution on my own but still haven't found it. I'm trying to convert 24 hour military time values to standard time. I have a query item called "start time" that is displaying as 1630 in my report and would like it to show as 4:30 PM.
Thank you for your help.
try to set the format in Data Format property
Thanks. I tried that that but it doesn't affect the values.
I made a video showing you how to do this ...
http://youtu.be/Azs8KsAyG4w
rih9000
8)
Thank you for taking the time to make the video which is great! Much appreciated!
Hi Again rih9000,
I was able to remove the comma in the report page by changing the data format to Number, then changing the "Use Thousands Separator" to No. However, if I try to change the data format to Time with the colon, it won't display--it reverts back to 1,200. How would I remove the comma and insert the colon?
Thank you.
There's more than one way to do that. Here is a video on my way:
http://youtu.be/XP3lF_80mu0
rih9000
:)
... in my video a few minutes ago, I forgot to subtract 12 from the military time. Here's the fix for that ...
https://www.youtube.com/watch?v=E9oZlz_YpQk
cheers
rih9000
8)
Thanks so much for the clear and helpful videos. A great solution! It's interesting that the data format property for time doesn't work for me either. On my desktop or laptop environments.