Problem with float in report
I have report with field memo: [frxDBDataset1."LOGINS_DURATION_TIME"]
This field is in DB in VIEW LOGINS as LOGINS_DATE_END-LOGINS_DATE_BEGIN
Sometimes its value is '00:00:05' - in field near 0.00013, but in my memo i see 0.13 !!!!
I want get this value and use TIMETOSTR and see 00:00:05 - but i see 10:23:21...
I attempt change VIEw and create field LOGINS_DATE_END-LOGINS_DATE_BEGIN+1 and in memo I see 1,0001000 not 1,000130. I need precise value because 0,0001000 its near 00:00:03 , 0.00013000 its near 00:00:05. 2 sec its big mistake when I have duration time <10s !!!
How i can display correct duration time?
This field is in DB in VIEW LOGINS as LOGINS_DATE_END-LOGINS_DATE_BEGIN
Sometimes its value is '00:00:05' - in field near 0.00013, but in my memo i see 0.13 !!!!
I want get this value and use TIMETOSTR and see 00:00:05 - but i see 10:23:21...
I attempt change VIEw and create field LOGINS_DATE_END-LOGINS_DATE_BEGIN+1 and in memo I see 1,0001000 not 1,000130. I need precise value because 0,0001000 its near 00:00:03 , 0.00013000 its near 00:00:05. 2 sec its big mistake when I have duration time <10s !!!
How i can display correct duration time?
Comments
and modify the format string to suit
hour:min:sec:msec am/pm, month day,year
msec can be 3 digit as below
hh:mm:ss:mss am/pm, mmmm dd, yyyy
I have 2 datatime: 2006-01-01 16:39:36 and 2006-01-01 16:39:49
and in DB a havale fiels datetime2-datetime1, in DB i see 0,000150462
but in report: 00:00:17 !!!! not 00:00:13