topic Time Function looses my minutes. in QlikView

Time Function looses my minutes.

Fri, 22 Jan 2010 18:12:38 GMT

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

Time Function looses my minutes.

Fri, 22 Jan 2010 19:13:51 GMT

Hello,

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

Steve

Time Function looses my minutes.

Sat, 23 Jan 2010 08:12:52 GMT

Thanx for the help ! It work perfect

// Daniel