Miltary Time & Select Record

Former Member — Fri, 31 Oct 2008 15:54:33 GMT

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?

Re: Miltary Time & Select Record

Former Member — Fri, 31 Oct 2008 16:00:26 GMT

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])


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

Question Re: Miltary Time & Select Record in Technology Q&A

Miltary Time & Select Record

Re: Miltary Time & Select Record