Leaderboard

I guess that the data format is the same as the DATE type: https://learn.microsoft.com/fr-fr/cpp/atl-mfc-shared/date-type?view=msvc-170 (sorry it seems the site switches to a localized page based on where you load it from.) So forget the int64 representation, get the value as a double and try from there. I'm always surprised by the various date/time proprietary and unpractical formats MS has invented out of thin air.

FileWrite in Excel ? Since all the time you have been here, you should know that writing a few lines of code out of context is truly useless to us. It would be nice from time to time to post a runable script that we can use as the base to help you find a solution. Anyway if you want to indent in excel, you need to use the property Range.IndentLevel like this : $oWorkBook.ActiveSheet.Range("E5").IndentLevel = 2 Of course I have no idea if this is what you are looking for...

Overlord, where are you ?

Progress Func _ReturnDateFromCOleDateTime($dColeDateDouble) Local $YR, $MN, $DD Local $iDaysToAdd = _DateToDayValue(1899, 12, 31) $Date = _DayValueToDate(Floor($dColeDateDouble) + $iDaysToAdd, $YR, $MN, $DD) Local $dAfterComma = $dColeDateDouble - (Floor($dColeDateDouble)) Local $iSeconds = ($dAfterComma * 24) * 60 * 60 Local $iHour = (Floor($iSeconds / 60 / 60)) Local $iMinute = (Floor($iSeconds / 60) - ($iHour * 60)) Local $iSecondsDisplay = (Floor($iSeconds - (($iMinute + ($iHour * 60)) * 60))) ConsoleWrite("Date:" & $YR & "-" & $MN & "-" & $DD & @CRLF) ConsoleWrite("Hours=" & $iHour & @CRLF) ConsoleWrite("Minutes=" & $iMinute & @CRLF) ConsoleWrite("Seconds=" & $iSecondsDisplay & @CRLF) EndFunc ;==>_ReturnDateFromCOleDate First thing what had to be done wat get the double instead of the UINT64 - thank you jchd !! This gave me the following double 44869.4435300926 the 44869 contained the date and the .4435300926 gave me the hours,minutes,second,ms _ReturnDateFromCOleDateTime(44869.4435300926) Resulted in a human readable date/time : Date:2022-11-05 Hours=10 Minutes=38 Seconds=41 Thank you water, pixelsearch and jchd !!

Works for me now with 22.611.2153.4, thanks a lot!

@KickStarter15 GuictrlSetData, will overwrite the contents of the edit control, @Psychobird25 look at the _GuiCtrlEdit functions for example: https://www.autoitscript.com/autoit3/docs/libfunctions/_GUICtrlEdit_AppendText.htm

Project has gone from incomplete to working for anyone whom this may be useful too. See first post.