Military Time
965732Oct 2 2012 — edited Oct 8 2012Afternoon,
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!