Time Function looses my minutes.

[#1]

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..

[#2 · Accepted solution]

Hello,

The problem is the format. Use 'HHmmSS' instead 'HHMMSS'. I think 'MM' is used for Months and 'mm' for minutes.

Steve

[#3]

Thanx for the help ! It work perfect

// Daniel