Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Military Time

965732Oct 2 2012 — edited Oct 8 2012
Afternoon,

I am trying to get my times to display in Military Times. Right now I have it stating 9/22/2012 7:03:00 PM and I need it to say 9/22/2012 19:03 instead.

Currently, my formula is just a filter:

filter ("- Terminal Task Measures"."Task Reported DateTime (Local)" using "Task Detail"."Task Code" = 'crew-in-wagon')

I am unsure of how to convert it to military time, would I create a new column then pull that formula into the new conversion formula, something like: conversionFormula(filter ("- Terminal Task Measures"."Task Reported DateTime (Local)" using "Task Detail"."Task Code" = 'crew-in-wagon')) ?

Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.