Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Convert standard time to military

Status
Not open for further replies.

cheryl1409

IS-IT--Management
May 12, 2011
2
US
I have a need to convert a field containing standard time formatting (7:45:27PM) to military time (19:45:27). Is there a known way to do this?
 
I should be more specific. I don't just need to visually format the field, I need to be able to calculate a difference between two dates and times and the only way I know to do that is if the time text string is in military format.
 
Hi,
If the fields are DateTime fields the DateDiff function in Crystal can compute the difference between them( See the Help files for details)



[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top