pcsoft.us.windevCopyright 2026, PC SOFT28 May 2018 20:58:00 Z28 May 2018 08:30:00 ZHi, there's an unexpected difficulty (only for me?) in calculating a duration. The problem is simple. A Date item (defined for YYYYMMDDhhmmssccc) of the file HISTORY receives the Log-in Date and Time: GPW_HISTORY.HISTORY_LOGIN = DateToString(DateSys(),"YYYYMMDD")+TimeToString(TimeSys(),"HHMMSS") Same goes for a logout. Whenever the main menue is closed then the log-out is recorded in another Date item GPW_HISTORY.HISTORY_LOGOUT = DateToString(DateSys(),"YYYYMMDD")+TimeToString(TimeSys(),"HHMMSS") Of course, there will be no logout Date+Time if the program crashes somewhen or as long as the user's session has not been terminated. A table control shows both items correctly in their columns (defined as Dates, returning YYYYMMDDhhmmss). One could be happy with that, but now I want to show the exact time which elapsed between a Log-in and Log-out in a third column of the table. I created a column with type of Duration, which will return DHHMMSSLLL and displays +2d d H h MM m SS s CCC ms. Using DateTimeDifference(..) of the LOGOUT / LOGIN datetime columns shows incorrect results! Does any of you know what's going on here or is there a solution?? The code IF Table.HISTORY_LOGIN <> Null AND Table.HISTORY_LOGOUT <> Null THEN DateTimeLOGIN = Table.HISTORY_LOGIN DateTimeLOGOUT = Table.HISTORY_LOGOUT MyDuration = DateTimeDifference(DateTimeLOGIN,DateTimeLOGOUT) Table.DAUER = MyDuration ELSE Table.DAUER = 0 END [attachment 2712 LoginDauer.png]30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65617-wd23-datetime-duration/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65617-wd23-datetime-duration-65628/read.awp28 May 2018 20:58:00 ZHi Guenter, yes the extra "0". I just remember that some time functions Need this, because they are counting the milliseconds…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65617-wd23-datetime-duration-65628/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65617-wd23-datetime-duration-65628/read.awp[WD23] DateTime / Durationguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65617-wd23-datetime-duration-65623/read.awp28 May 2018 10:57:00 ZHi Erik, thank you! Yes, I saw that ... after some tweaking the code the solution looks quite simple like that: DateTimeLOGIN…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65617-wd23-datetime-duration-65623/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65617-wd23-datetime-duration-65623/read.awp[WD23] DateTime / Durationguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65617-wd23-datetime-duration-65622/read.awp28 May 2018 09:24:00 ZHi Günter, seems to be a formatting Problem only. The values are correct, for example the first two lines: 01s300ms (sh…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65617-wd23-datetime-duration-65622/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65617-wd23-datetime-duration-65622/read.awp[WD23] DateTime / Duration