Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
glcordell
Contributor II
Contributor II

Convert Regular Time to Military Time

I have a date and time field with the time field in regular time (AM/PM). I want to convert the combination into military time. The date field is Service Date and the time field is Service.Service Start Time. Any help would be appreciated. Thanks in advance.

Labels (1)
1 Solution

Accepted Solutions
Taoufiq_Zarra

@glcordell  you can try :

TimeStamp(Timestamp#(RegularTime,'MM-DD-YYYY hh:mm:ss TT'),'MM-DD-YYYY hh:mm:ss') as MilitaryTime

 

for example :

Data:

load 
*,TimeStamp(Timestamp#(RegularTime,'MM-DD-YYYY hh:mm:ss TT'),'MM-DD-YYYY hh:mm:ss') as MilitaryTime
inline [
RegularTime
09-03-20 9:07:28 AM
];

output:

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

2 Replies
Taoufiq_Zarra

@glcordell  you can try :

TimeStamp(Timestamp#(RegularTime,'MM-DD-YYYY hh:mm:ss TT'),'MM-DD-YYYY hh:mm:ss') as MilitaryTime

 

for example :

Data:

load 
*,TimeStamp(Timestamp#(RegularTime,'MM-DD-YYYY hh:mm:ss TT'),'MM-DD-YYYY hh:mm:ss') as MilitaryTime
inline [
RegularTime
09-03-20 9:07:28 AM
];

output:

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
glcordell
Contributor II
Contributor II
Author

Thanks so much!!