Forum Discussion

Damon_Wang's avatar
Damon_Wang
Occasional Contributor
12 years ago

Start time and stop time in Description.tcLog

I got start time in Description.tcLog like this 41645.0917384028, could anyone tell me what date it is? It seems it's based on a time 1899/12/30? Why it's not 1899/12/31?
TanyaYatskovska's avatar
TanyaYatskovska
Icon for Alumni rankAlumni
12 years ago

Hi Damon,


 


Convert the digit format to Date - it will be 1/6/2014 2:12:06 AM. Here is the code I used for the conversion:




   //JScript


   var oaDate = VarToFloat(41645.0917384028);


   Log.Message(aqConvert.DateTimeToStr(oaDate));