2 Replies Latest reply: Jan 23, 2010 3:12 AM by BitnByte RSS

    Time Function looses my minutes.

    BitnByte

      Hi

      I loose my Minutes!

      The DJRGTM field in the database is "231034"

      But when I use this line below
      Time(Time#(Right(num(DJRGTM, '000000'),6),'HHMMSS')) as EntryTime

      Then the answer in QV is 23:00:34

      The same is for all minute's
      for example 231111 -> 23:00:11

      Thanx for any replies..