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?

Comments

  • gordkgordk St.Catherines On. Canada.
    edited 1:29PM
    set the display format property for the memo to tdatetime
    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
  • edited 1:29PM
    Its no work - i have good display format, but wrong valueas:
    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

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.