Miltary Time & Select Record

[Former Member]

The database that hold the time stores the data in military time. For example: 7:15 a.m. is stored as 71500 (no leading zeroes,hr,min,sec) and 10:20 a.m. is store as 102000. Any ideas on how I can compare the time for a report?

[Former Member · Accepted solution]

Try

NUMBERVAR HourSplit := TRUNCATE({Data.Value});
NUMBERVAR MinuteSplit := 60 * ({Data.Value} - HourSplit);
TIME (HourSplit, MinuteSplit, 0)

Taken from (source: [https://boc.sdn.sap.com/node/569])

OR

ConvertTime
WhilePrintingRecords;
Local NumberVar ConvertTime := {YourTimeField};

Local NumberVar MyHours;
Local NumberVar  MyMinutes;
Local NumberVar MySeconds;

MyHours := ConvertTime \ 10000;
ConvertTime := ConvertTime mod 10000;
MyMinutes := ConvertTime \ 100;
MySeconds := ConvertTime mod 100;

Time(MyHours,MyMinutes,MySeconds)

Taken from [http://www.experts-exchange.com/Database/Reporting_/Crystal_Reports/Q_22941155.html]

Regards

Jehanzeb